Pandas Profiling Report

Dataset info

Number of variables	183
Number of observations	265
Missing cells	21158 (43.6%)
Duplicate rows	0 (0.0%)
Total size in memory	365.6 KiB
Average record size in memory	1.4 KiB

Variables types

Numeric	63
Categorical	23
Boolean	25
Date	0
URL	0
Text (Unique)	1
Rejected	71
Unsupported	0

Warnings

`coligada_mais_antiga_ativa` has 189 (71.3%) missing values	Missing
`coligada_mais_antiga_baixada` has 264 (99.6%) missing values	Missing
`coligada_mais_nova_ativa` has 189 (71.3%) missing values	Missing
`coligada_mais_nova_baixada` has 264 (99.6%) missing values	Missing
`de_indicador_telefone` has 71 (26.8%) missing values	Missing
`dt_situacao` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`dt_situacao` has a high cardinality: 129 distinct values	Warning
`empsetorcensitariofaixarendapopulacao` has 48 (18.1%) missing values	Missing
`faturamento_est_coligados` has 191 (72.1%) missing values	Missing
`faturamento_est_coligados_gp` is highly correlated with `faturamento_est_coligados` (ρ = 0.9725637856)	Rejected
`fl_epp` has constant value "False"	Rejected
`fl_matriz` has constant value "True"	Rejected
`fl_me` has constant value "False"	Rejected
`fl_mei` has constant value "False"	Rejected
`fl_passivel_iss` has constant value "True"	Rejected
`fl_st_especial` has constant value "False"	Rejected
`grau_instrucao_macro_analfabeto` has 201 (75.8%) missing values	Missing
`grau_instrucao_macro_desconhecido` has constant value "nan"	Rejected
`grau_instrucao_macro_escolaridade_fundamental` has 12 (4.5%) missing values	Missing
`grau_instrucao_macro_escolaridade_superior` has 3 (1.1%) missing values	Missing
`idade_acima_de_58` has 8 (3.0%) missing values	Missing
`idade_ate_18` has 208 (78.5%) missing values	Missing
`idade_de_19_a_23` has 76 (28.7%) missing values	Missing
`idade_de_24_a_28` is highly correlated with `idade_de_19_a_23` (ρ = 0.9391201682)	Rejected
`idade_de_39_a_43` is highly correlated with `idade_de_34_a_38` (ρ = 0.9147291585)	Rejected
`idade_de_44_a_48` is highly correlated with `idade_de_39_a_43` (ρ = 0.9376949593)	Rejected
`idade_de_54_a_58` is highly correlated with `idade_acima_de_58` (ρ = 0.9500453674)	Rejected
`idade_maxima_coligadas` is highly correlated with `coligada_mais_antiga_ativa` (ρ = 0.990757127)	Rejected
`idade_maxima_socios` has 172 (64.9%) missing values	Missing
`idade_media_coligadas` has 189 (71.3%) missing values	Missing
`idade_media_coligadas_ativas` is highly correlated with `idade_media_coligadas` (ρ = 0.9928275535)	Rejected
`idade_media_coligadas_baixadas` has 264 (99.6%) missing values	Missing
`idade_media_socios` has 172 (64.9%) missing values	Missing
`idade_minima_coligadas` is highly correlated with `coligada_mais_nova_ativa` (ρ = 1)	Rejected
`idade_minima_socios` is highly correlated with `idade_media_socios` (ρ = 0.9030093563)	Rejected
`max_faturamento_est_coligados` is highly correlated with `faturamento_est_coligados` (ρ = 0.9484709664)	Rejected
`max_faturamento_est_coligados_gp` is highly correlated with `max_faturamento_est_coligados` (ρ = 0.9515331439)	Rejected
`max_filiais_coligados` has 229 (86.4%) missing values	Missing
`max_funcionarios_coligados_gp` is highly correlated with `max_filiais_coligados` (ρ = 0.9312487825)	Rejected
`max_vl_folha_coligados` has 207 (78.1%) missing values	Missing
`max_vl_folha_coligados_gp` has 206 (77.7%) missing values	Missing
`media_faturamento_est_coligados` is highly correlated with `max_faturamento_est_coligados` (ρ = 0.9075319591)	Rejected
`media_faturamento_est_coligados_gp` is highly correlated with `media_faturamento_est_coligados` (ρ = 0.9465645673)	Rejected
`media_filiais_coligados` has 229 (86.4%) missing values	Missing
`media_funcionarios_coligados_gp` has 4 (1.5%) zeros	Zeros
`media_funcionarios_coligados_gp` has 202 (76.2%) missing values	Missing
`media_vl_folha_coligados` has 207 (78.1%) missing values	Missing
`media_vl_folha_coligados_gp` has 206 (77.7%) missing values	Missing
`min_faturamento_est_coligados` has 191 (72.1%) missing values	Missing
`min_faturamento_est_coligados_gp` is highly correlated with `min_faturamento_est_coligados` (ρ = 0.9844779291)	Rejected
`min_filiais_coligados` has 229 (86.4%) missing values	Missing
`min_funcionarios_coligados_gp` is highly correlated with `min_filiais_coligados` (ρ = 0.916066893)	Rejected
`min_meses_servicos` is highly correlated with `meses_ultima_contratacaco` (ρ = 0.9567491686)	Rejected
`min_meses_servicos_all` has 19 (7.2%) zeros	Zeros
`min_vl_folha_coligados` is highly correlated with `min_funcionarios_coligados_gp` (ρ = 0.9989755332)	Rejected
`min_vl_folha_coligados_gp` is highly correlated with `min_vl_folha_coligados` (ρ = 0.9991732114)	Rejected
`nm_meso_regiao` has 24 (9.1%) missing values	Missing
`nm_micro_regiao` has a high cardinality: 57 distinct values	Warning
`nm_micro_regiao` has 24 (9.1%) missing values	Missing
`qt_admitidos_12meses` has 162 (61.1%) zeros	Zeros
`qt_alteracao_socio_180d` has constant value "nan"	Rejected
`qt_alteracao_socio_365d` has constant value "nan"	Rejected
`qt_alteracao_socio_90d` has constant value "nan"	Rejected
`qt_alteracao_socio_total` has constant value "nan"	Rejected
`qt_art` has 135 (50.9%) missing values	Missing
`qt_coligadas` has 189 (71.3%) missing values	Missing
`qt_coligados` is highly correlated with `qt_coligadas` (ρ = 1)	Rejected
`qt_coligados_agropecuaria` has 189 (71.3%) missing values	Missing
`qt_coligados_atividade_alto` has 189 (71.3%) missing values	Missing
`qt_coligados_atividade_baixo` has 189 (71.3%) missing values	Missing
`qt_coligados_atividade_inativo` has 189 (71.3%) missing values	Missing
`qt_coligados_atividade_medio` has 189 (71.3%) missing values	Missing
`qt_coligados_atividade_mt_baixo` has 189 (71.3%) missing values	Missing
`qt_coligados_ativo` is highly correlated with `qt_coligados` (ρ = 0.9997516702)	Rejected
`qt_coligados_baixada` is highly correlated with `max_funcionarios_coligados_gp` (ρ = 0.9718460044)	Rejected
`qt_coligados_ccivil` has 189 (71.3%) missing values	Missing
`qt_coligados_centro` has 68 (25.7%) zeros	Zeros
`qt_coligados_centro` has 189 (71.3%) missing values	Missing
`qt_coligados_comercio` has 46 (17.4%) zeros	Zeros
`qt_coligados_comercio` has 189 (71.3%) missing values	Missing
`qt_coligados_epp` has 189 (71.3%) missing values	Missing
`qt_coligados_exterior` has 189 (71.3%) missing values	Missing
`qt_coligados_inapta` is highly correlated with `max_funcionarios_coligados_gp` (ρ = 0.9718460044)	Rejected
`qt_coligados_industria` has 63 (23.8%) zeros	Zeros
`qt_coligados_industria` has 189 (71.3%) missing values	Missing
`qt_coligados_ltda` has 69 (26.0%) zeros	Zeros
`qt_coligados_ltda` has 189 (71.3%) missing values	Missing
`qt_coligados_matriz` is highly correlated with `qt_coligados_ativo` (ρ = 0.9996971343)	Rejected
`qt_coligados_me` has 189 (71.3%) missing values	Missing
`qt_coligados_mei` has 189 (71.3%) missing values	Missing
`qt_coligados_nordeste` has 31 (11.7%) zeros	Zeros
`qt_coligados_nordeste` has 189 (71.3%) missing values	Missing
`qt_coligados_norte` has 39 (14.7%) zeros	Zeros
`qt_coligados_norte` has 189 (71.3%) missing values	Missing
`qt_coligados_nula` has 189 (71.3%) missing values	Missing
`qt_coligados_sa` has 64 (24.2%) zeros	Zeros
`qt_coligados_sa` has 189 (71.3%) missing values	Missing
`qt_coligados_serviço` is highly correlated with `qt_coligados_matriz` (ρ = 0.9288399907)	Rejected
`qt_coligados_sudeste` has 65 (24.5%) zeros	Zeros
`qt_coligados_sudeste` has 189 (71.3%) missing values	Missing
`qt_coligados_sul` is highly correlated with `qt_coligados_baixada` (ρ = 0.9612903226)	Rejected
`qt_coligados_suspensa` has 189 (71.3%) missing values	Missing
`qt_desligados` is highly correlated with `qt_admitidos` (ρ = 0.905610227)	Rejected
`qt_desligados_12meses` has 159 (60.0%) zeros	Zeros
`qt_ex_funcionarios` is highly correlated with `qt_desligados` (ρ = 0.9999991015)	Rejected
`qt_filiais` has 155 (58.5%) zeros	Zeros
`qt_funcionarios_12meses` is highly correlated with `qt_funcionarios` (ρ = 0.9948729203)	Rejected
`qt_funcionarios_24meses` is highly correlated with `qt_funcionarios_12meses` (ρ = 0.968894117)	Rejected
`qt_funcionarios_coligados` has 5 (1.9%) zeros	Zeros
`qt_funcionarios_coligados` has 202 (76.2%) missing values	Missing
`qt_funcionarios_coligados_gp` is highly correlated with `qt_coligados_inapta` (ρ = 0.9231363224)	Rejected
`qt_funcionarios_grupo` is highly correlated with `qt_funcionarios_24meses` (ρ = 0.9502971077)	Rejected
`qt_ramos_coligados` is highly correlated with `qt_coligados_matriz` (ρ = 0.9346159264)	Rejected
`qt_regioes_coligados` has 189 (71.3%) missing values	Missing
`qt_socios` is highly correlated with `qt_coligados_mei` (ρ = 0.9899466719)	Rejected
`qt_socios_coligados` has 189 (71.3%) missing values	Missing
`qt_socios_feminino` is highly correlated with `qt_socios` (ρ = 0.9936468189)	Rejected
`qt_socios_masculino` is highly correlated with `qt_socios_feminino` (ρ = 0.9916264524)	Rejected
`qt_socios_pep` is highly correlated with `qt_socios_masculino` (ρ = 0.9954550751)	Rejected
`qt_socios_pf` is highly correlated with `qt_socios_pep` (ρ = 0.9960939342)	Rejected
`qt_socios_pj` has 83 (31.3%) zeros	Zeros
`qt_socios_pj` has 167 (63.0%) missing values	Missing
`qt_socios_pj_ativos` is highly correlated with `qt_socios_pj` (ρ = 1)	Rejected
`qt_socios_pj_baixados` has 250 (94.3%) missing values	Missing
`qt_socios_pj_inaptos` has 250 (94.3%) missing values	Missing
`qt_socios_pj_nulos` has 250 (94.3%) missing values	Missing
`qt_socios_pj_suspensos` has 250 (94.3%) missing values	Missing
`qt_socios_st_regular` is highly correlated with `qt_socios_pf` (ρ = 0.9983592345)	Rejected
`qt_socios_st_suspensa` has constant value "nan"	Rejected
`qt_ufs_coligados` is highly correlated with `qt_regioes_coligados` (ρ = 0.9026409791)	Rejected
`setor` has constant value "SERVIÇO"	Rejected
`sg_uf_matriz` is a recoding of `sg_uf`	Rejected
`sum_faturamento_estimado_coligadas` is highly correlated with `media_faturamento_est_coligados_gp` (ρ = 0.9016602831)	Rejected
`total` is highly correlated with `qt_funcionarios_grupo` (ρ = 0.9743124436)	Rejected
`total_filiais_coligados` is highly correlated with `qt_funcionarios_coligados_gp` (ρ = 0.9354643228)	Rejected
`tx_crescimento_12meses` has 161 (60.8%) zeros	Zeros
`tx_crescimento_24meses` is highly correlated with `tx_crescimento_12meses` (ρ = 0.9959598268)	Rejected
`tx_rotatividade` has 160 (60.4%) zeros	Zeros
`Unnamed_0_y` is highly correlated with `Unnamed_0_x` (ρ = 0.9988970638)	Rejected
`vl_faturamento_estimado_grupo_aux` is highly correlated with `vl_faturamento_estimado_aux` (ρ = 0.9811022766)	Rejected
`vl_folha_coligados` is highly correlated with `qt_funcionarios_coligados` (ρ = 0.961120251)	Rejected
`vl_folha_coligados_gp` is highly correlated with `vl_folha_coligados` (ρ = 0.9428868609)	Rejected
`vl_frota` is highly correlated with `qt_socios_pep` (ρ = 0.9138805515)	Rejected
`vl_idade_maxima_socios_pj` has 250 (94.3%) missing values	Missing
`vl_idade_media_socios_pj` has 250 (94.3%) missing values	Missing
`vl_idade_minima_socios_pj` has 250 (94.3%) missing values	Missing
`vl_potenc_cons_oleo_gas` has 243 (91.7%) missing values	Missing
`vl_total_tancagem` has 255 (96.2%) missing values	Missing
`vl_total_tancagem_grupo` is highly correlated with `vl_idade_minima_socios_pj` (ρ = 0.9444166274)	Rejected
`vl_total_veiculos_antt` has constant value "nan"	Rejected
`vl_total_veiculos_antt_grupo` has constant value "nan"	Rejected
`vl_total_veiculos_leves` is highly correlated with `qt_socios_pep` (ρ = 0.9328182339)	Rejected
`vl_total_veiculos_leves_grupo` is highly correlated with `vl_total_veiculos_leves` (ρ = 0.9972729314)	Rejected
`vl_total_veiculos_pesados` is highly correlated with `vl_potenc_cons_oleo_gas` (ρ = 0.9929030146)	Rejected
`vl_total_veiculos_pesados_grupo` is highly correlated with `vl_total_veiculos_pesados` (ρ = 0.9978083954)	Rejected

coligada_mais_antiga_ativa
Numeric

Distinct count	77
Unique (%)	29.1%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	289.7526316
Minimum	2.3
Maximum	642.6666667
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2.3
5-th percentile	24.475
Q1	116.3083333
Median	272.7833333
Q3	414.3416667
95-th percentile	634.2166667
Maximum	642.6666667
Range	640.3666667
Interquartile range	298.0333333

Descriptive statistics

Standard deviation	193.4929426
Coef of variation	0.667786662
Kurtosis	-1.021551163
Mean	289.7526316
MAD	162.5111727
Skewness	0.318938033
Sum	22021.2
Variance	37439.51885
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
408.4666667	1	0.4%
25.56666667	1	0.4%
42.36666667	1	0.4%
273.1666667	1	0.4%
194.2333333	1	0.4%
74.76666667	1	0.4%
5.8	1	0.4%
404.8	1	0.4%
178.3666667	1	0.4%
108.4666667	1	0.4%
Other values (66)	66	24.9%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
2.3	1	0.4%
5.8	1	0.4%
19.1	1	0.4%
21.2	1	0.4%
25.56666667	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
642.6666667	1	0.4%
635.4666667	1	0.4%
635.2333333	1	0.4%
634.2666667	1	0.4%
634.2	1	0.4%

coligada_mais_antiga_baixada
Categorical

Distinct count	2
Unique (%)	0.8%
Missing (%)	99.6%
Missing (n)	264

190.9	1
(Missing)	264

Toggle details

Common values
Composition

Value	Count	Frequency (%)
190.9	1	0.4%
(Missing)	264	99.6%

Max length	5
Mean length	3.00754717
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

coligada_mais_nova_ativa
Numeric

Distinct count	74
Unique (%)	27.9%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	92.76929825
Minimum	2.033333333
Maximum	498.9666667
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2.033333333
5-th percentile	3.65
Q1	16.65833333
Median	39.41666667
Q3	122.0416667
95-th percentile	334.4
Maximum	498.9666667
Range	496.9333333
Interquartile range	105.3833333

Descriptive statistics

Standard deviation	110.7867162
Coef of variation	1.194217466
Kurtosis	2.452633587
Mean	92.76929825
MAD	84.73578024
Skewness	1.677094953
Sum	7050.466667
Variance	12273.6965
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21.2	2	0.8%
19.1	2	0.8%
96.96666667	2	0.8%
109.8333333	1	0.4%
8.033333333	1	0.4%
83.83333333	1	0.4%
95.96666667	1	0.4%
377.9	1	0.4%
116.1333333	1	0.4%
222	1	0.4%
Other values (63)	63	23.8%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
2.033333333	1	0.4%
2.3	1	0.4%
2.4	1	0.4%
3.2	1	0.4%
3.8	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
498.9666667	1	0.4%
408.4666667	1	0.4%
377.9	1	0.4%
355.8	1	0.4%
327.2666667	1	0.4%

coligada_mais_nova_baixada
Categorical

Distinct count	2
Unique (%)	0.8%
Missing (%)	99.6%
Missing (n)	264

190.9	1
(Missing)	264

Toggle details

Common values
Composition

Value	Count	Frequency (%)
190.9	1	0.4%
(Missing)	264	99.6%

Max length	5
Mean length	3.00754717
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

de_faixa_faturamento_estimado
Categorical

Distinct count	6
Unique (%)	2.3%
Missing (%)	0.0%
Missing (n)	0

DE R$ 30.000.000,01 A R$ 100.000.000,00	138
DE R$ 10.000.000,01 A R$ 30.000.000,00	61
DE R$ 100.000.000,01 A R$ 300.000.000,00	49
Other values (3)	17

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DE R$ 30.000.000,01 A R$ 100.000.000,00	138	52.1%
DE R$ 10.000.000,01 A R$ 30.000.000,00	61	23.0%
DE R$ 100.000.000,01 A R$ 300.000.000,00	49	18.5%
DE R$ 300.000.000,01 A R$ 500.000.000,00	9	3.4%
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	6	2.3%
ACIMA DE 1 BILHAO DE REAIS	2	0.8%

Max length	40
Mean length	38.91320755
Min length	26
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count	6
Unique (%)	2.3%
Missing (%)	0.0%
Missing (n)	0

DE R$ 30.000.000,01 A R$ 100.000.000,00	135
DE R$ 10.000.000,01 A R$ 30.000.000,00	59
DE R$ 100.000.000,01 A R$ 300.000.000,00	54
Other values (3)	17

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DE R$ 30.000.000,01 A R$ 100.000.000,00	135	50.9%
DE R$ 10.000.000,01 A R$ 30.000.000,00	59	22.3%
DE R$ 100.000.000,01 A R$ 300.000.000,00	54	20.4%
DE R$ 300.000.000,01 A R$ 500.000.000,00	7	2.6%
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	7	2.6%
ACIMA DE 1 BILHAO DE REAIS	3	1.1%

Max length	40
Mean length	38.88679245
Min length	26
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_indicador_telefone
Categorical

Distinct count	2
Unique (%)	0.8%
Missing (%)	26.8%
Missing (n)	71

BOA	194
(Missing)	71

Toggle details

Common values
Composition

Value	Count	Frequency (%)
BOA	194	73.2%
(Missing)	71	26.8%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

de_natureza_juridica
Categorical

Distinct count	25
Unique (%)	9.4%
Missing (%)	0.0%
Missing (n)	0

MUNICIPIO	108
SOCIEDADE EMPRESARIA LIMITADA	62
ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL	20
Other values (22)	75

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MUNICIPIO	108	40.8%
SOCIEDADE EMPRESARIA LIMITADA	62	23.4%
ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL	20	7.5%
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA	13	4.9%
ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL	9	3.4%
ASSOCIACAO PRIVADA	8	3.0%
AUTARQUIA ESTADUAL OU DO DISTRITO FEDERAL	6	2.3%
SERVICO SOCIAL AUTONOMO	5	1.9%
COOPERATIVA	4	1.5%
AUTARQUIA FEDERAL	4	1.5%
Other values (15)	26	9.8%

Max length	70
Mean length	25.58490566
Min length	9
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_nivel_atividade
Categorical

Distinct count	3
Unique (%)	1.1%
Missing (%)	0.0%
Missing (n)	0

ALTA	236
MEDIA	26
BAIXA	3

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ALTA	236	89.1%
MEDIA	26	9.8%
BAIXA	3	1.1%

Max length	5
Mean length	4.109433962
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

de_ramo
Categorical

Distinct count	16
Unique (%)	6.0%
Missing (%)	0.0%
Missing (n)	0

ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	150
SERVICOS ADMINISTRATIVOS	35
SERVICOS DE EDUCACAO	22
Other values (13)	58

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	150	56.6%
SERVICOS ADMINISTRATIVOS	35	13.2%
SERVICOS DE EDUCACAO	22	8.3%
TRANSPORTE, ARMAZENAGEM E CORREIO	14	5.3%
SERVICOS DE SAUDE	13	4.9%
SERVICOS DE SANEAMENTO BASICO	5	1.9%
SERVICOS DE ALOJAMENTO/ALIMENTACAO	5	1.9%
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS	5	1.9%
SERVICOS DIVERSOS	4	1.5%
TELECOM	3	1.1%
Other values (6)	9	3.4%

Max length	49
Mean length	38.54716981
Min length	7
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_saude_rescencia
Categorical

Distinct count	3
Unique (%)	1.1%
Missing (%)	0.0%
Missing (n)	0

ACIMA DE 1 ANO	263
SEM INFORMACAO	1
ATE 1 ANO	1

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ACIMA DE 1 ANO	263	99.2%
SEM INFORMACAO	1	0.4%
ATE 1 ANO	1	0.4%

Max length	14
Mean length	13.98113208
Min length	9
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_saude_tributaria
Categorical

Distinct count	5
Unique (%)	1.9%
Missing (%)	0.0%
Missing (n)	0

VERDE	159
AZUL	83
LARANJA	20
Other values (2)	3

Toggle details

Common values
Composition

Value	Count	Frequency (%)
VERDE	159	60.0%
AZUL	83	31.3%
LARANJA	20	7.5%
VERMELHO	2	0.8%
CINZA	1	0.4%

Max length	8
Mean length	4.860377358
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

dt_situacao
Categorical

Distinct count	129
Unique (%)	48.7%
Missing (%)	0.0%
Missing (n)	0

2005-11-03	85
1998-07-28	13
2005-09-24	10
Other values (126)	157

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2005-11-03	85	32.1%
1998-07-28	13	4.9%
2005-09-24	10	3.8%
2005-10-14	4	1.5%
1999-02-27	4	1.5%
2005-08-27	4	1.5%
2005-10-28	4	1.5%
2005-10-07	3	1.1%
2005-08-06	3	1.1%
2005-10-22	3	1.1%
Other values (119)	132	49.8%

Max length	10
Mean length	10
Min length	10
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count	208
Unique (%)	78.5%
Missing (%)	18.1%
Missing (n)	48
Infinite (%)	0.0%
Infinite (n)	0

Mean	1587.10682
Minimum	297.41
Maximum	6347.86
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	297.41
5-th percentile	405.494
Q1	708.95
Median	1072.28
Q3	2179.92
95-th percentile	4133.876
Maximum	6347.86
Range	6050.45
Interquartile range	1470.97

Descriptive statistics

Standard deviation	1235.757393
Coef of variation	0.7786226969
Kurtosis	2.385943631
Mean	1587.10682
MAD	949.6950676
Skewness	1.588122545
Sum	344402.18
Variance	1527096.333
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1005.09	3	1.1%
1068.09	2	0.8%
2317.14	2	0.8%
1881.35	2	0.8%
2179.92	2	0.8%
1213.54	2	0.8%
1375.69	2	0.8%
2799.81	2	0.8%
1530.23	2	0.8%
960.76	1	0.4%
Other values (197)	197	74.3%
(Missing)	48	18.1%

Minimum 5 values

Value	Count	Frequency (%)
297.41	1	0.4%
339.08	1	0.4%
353.66	1	0.4%
365.15	1	0.4%
365.3	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
6347.86	1	0.4%
5985.49	1	0.4%
5985.39	1	0.4%
5463.12	1	0.4%
5261.19	1	0.4%

faturamento_est_coligados
Numeric

Distinct count	62
Unique (%)	23.4%
Missing (%)	72.1%
Missing (n)	191
Infinite (%)	0.0%
Infinite (n)	0

Mean	289284759.7
Minimum	123638.3984
Maximum	7559949122
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	123638.3984
5-th percentile	210000
Q1	807279.6094
Median	5192125.824
Q3	55464072.81
95-th percentile	710049020.8
Maximum	7559949122
Range	7559825483
Interquartile range	54656793.2

Descriptive statistics

Standard deviation	1135823648
Coef of variation	3.926316923
Kurtosis	28.39111034
Mean	289284759.7
MAD	458450248.1
Skewness	5.228047835
Sum	2.140707222e+10
Variance	1.290095359e+18
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
210000	10	3.8%
420000	3	1.1%
930000	2	0.8%
494553.5938	2	0.8%
5223030950	1	0.4%
84164409.75	1	0.4%
3727151686	1	0.4%
11282004	1	0.4%
928938553.6	1	0.4%
3449140.75	1	0.4%
Other values (51)	51	19.2%
(Missing)	191	72.1%

Minimum 5 values

Value	Count	Frequency (%)
123638.3984	1	0.4%
210000	10	3.8%
247276.7969	1	0.4%
288489.5938	1	0.4%
420000	3	1.1%

Maximum 5 values

Value	Count	Frequency (%)
7559949122	1	0.4%
5223030950	1	0.4%
3727151686	1	0.4%
928938553.6	1	0.4%
592185426.2	1	0.4%

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation	0.9725637856

fl_antt
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

False	253
True	12

Toggle details

Value	Count	Frequency (%)
False	253	95.5%
True	12	4.5%

fl_email
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

False	147
True	118

Toggle details

Value	Count	Frequency (%)
False	147	55.5%
True	118	44.5%

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant value	False

fl_ltda
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

False	264
True	1

Toggle details

Value	Count	Frequency (%)
False	264	99.6%
True	1	0.4%

fl_matriz
Constant

This variable is constant and should be ignored for analysis

Constant value	True

fl_me
Constant

This variable is constant and should be ignored for analysis

Constant value	False

fl_mei
Constant

This variable is constant and should be ignored for analysis

Constant value	False

fl_optante_simei
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.8%
Missing (n)	2

False	263
(Missing)	2

Toggle details

Value	Count	Frequency (%)
False	263	99.2%
(Missing)	2	0.8%

fl_optante_simples
Boolean

Distinct count	3
Unique (%)	1.1%
Missing (%)	0.8%
Missing (n)	2

False	252
True	11
(Missing)	2

Toggle details

Value	Count	Frequency (%)
False	252	95.1%
True	11	4.2%
(Missing)	2	0.8%

fl_passivel_iss
Constant

This variable is constant and should be ignored for analysis

Constant value	True

fl_rm
Categorical

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

NAO	145
SIM	120

Toggle details

Common values
Composition

Value	Count	Frequency (%)
NAO	145	54.7%
SIM	120	45.3%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

fl_sa
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

False	260
True	5

Toggle details

Value	Count	Frequency (%)
False	260	98.1%
True	5	1.9%

fl_simples_irregular
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

False	264
True	1

Toggle details

Value	Count	Frequency (%)
False	264	99.6%
True	1	0.4%

fl_spa
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

False	255
True	10

Toggle details

Value	Count	Frequency (%)
False	255	96.2%
True	10	3.8%

fl_st_especial
Constant

This variable is constant and should be ignored for analysis

Constant value	False

fl_telefone
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

False	133
True	132

Toggle details

Value	Count	Frequency (%)
False	133	50.2%
True	132	49.8%

fl_veiculo
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

True	221
False	44

Toggle details

Value	Count	Frequency (%)
True	221	83.4%
False	44	16.6%

grau_instrucao_macro_analfabeto
Numeric

Distinct count	15
Unique (%)	5.7%
Missing (%)	75.8%
Missing (n)	201
Infinite (%)	0.0%
Infinite (n)	0

Mean	6.21875
Minimum	1
Maximum	66
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	2
Q3	4.25
95-th percentile	24
Maximum	66
Range	65
Interquartile range	3.25

Descriptive statistics

Standard deviation	12.3564375
Coef of variation	1.986964824
Kurtosis	15.39379909
Mean	6.21875
MAD	6.692382812
Skewness	3.805688551
Sum	398
Variance	152.6815476
Memory size	14.1 KiB

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
1	24	9.1%
2	13	4.9%
3	8	3.0%
24	3	1.1%
4	3	1.1%
9	2	0.8%
8	2	0.8%
6	2	0.8%
7	2	0.8%
64	1	0.4%
Other values (4)	4	1.5%
(Missing)	201	75.8%

Minimum 5 values

Value	Count	Frequency (%)
1	24	9.1%
2	13	4.9%
3	8	3.0%
4	3	1.1%
5	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
66	1	0.4%
64	1	0.4%
33	1	0.4%
24	3	1.1%
12	1	0.4%

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

grau_instrucao_macro_escolaridade_fundamental
Numeric

Distinct count	130
Unique (%)	49.1%
Missing (%)	4.5%
Missing (n)	12
Infinite (%)	0.0%
Infinite (n)	0

Mean	76.55335968
Minimum	1
Maximum	668
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1.6
Q1	15
Median	45
Q3	96
95-th percentile	253
Maximum	668
Range	667
Interquartile range	81

Descriptive statistics

Standard deviation	105.8099999
Coef of variation	1.38217317
Kurtosis	11.1841695
Mean	76.55335968
MAD	66.39581934
Skewness	3.086906223
Sum	19368
Variance	11195.75607
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	13	4.9%
18	7	2.6%
19	6	2.3%
4	6	2.3%
7	6	2.3%
9	5	1.9%
17	5	1.9%
15	5	1.9%
54	5	1.9%
12	5	1.9%
Other values (119)	190	71.7%
(Missing)	12	4.5%

Minimum 5 values

Value	Count	Frequency (%)
1	13	4.9%
2	4	1.5%
3	4	1.5%
4	6	2.3%
5	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
668	1	0.4%
595	1	0.4%
576	1	0.4%
559	1	0.4%
499	1	0.4%

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count	196
Unique (%)	74.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	221.0264151
Minimum	4
Maximum	2447
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4
5-th percentile	23
Q1	73
Median	140
Q3	255
95-th percentile	638.6
Maximum	2447
Range	2443
Interquartile range	182

Descriptive statistics

Standard deviation	273.2013411
Coef of variation	1.236057423
Kurtosis	22.39937334
Mean	221.0264151
MAD	162.8438305
Skewness	3.971661552
Sum	58572
Variance	74638.97278
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 4. 150.5 255.5 400.5 722.5 2447. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
134	4	1.5%
145	4	1.5%
49	4	1.5%
35	3	1.1%
122	3	1.1%
23	3	1.1%
117	3	1.1%
252	3	1.1%
40	3	1.1%
107	3	1.1%
Other values (186)	232	87.5%

Minimum 5 values

Value	Count	Frequency (%)
4	1	0.4%
5	1	0.4%
6	2	0.8%
9	1	0.4%
11	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
2447	1	0.4%
1662	1	0.4%
1581	1	0.4%
1193	2	0.8%
1164	1	0.4%

grau_instrucao_macro_escolaridade_superior
Numeric

Distinct count	179
Unique (%)	67.5%
Missing (%)	1.1%
Missing (n)	3
Infinite (%)	0.0%
Infinite (n)	0

Mean	174.0419847
Minimum	1
Maximum	2471
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	3
Q1	40.25
Median	90
Q3	192.75
95-th percentile	567.75
Maximum	2471
Range	2470
Interquartile range	152.5

Descriptive statistics

Standard deviation	272.8321487
Coef of variation	1.567622601
Kurtosis	26.49629512
Mean	174.0419847
MAD	155.0061768
Skewness	4.407661604
Sum	45599
Variance	74437.38137
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	7	2.6%
2	5	1.9%
56	4	1.5%
8	4	1.5%
7	4	1.5%
72	4	1.5%
63	4	1.5%
44	3	1.1%
13	3	1.1%
37	3	1.1%
Other values (168)	221	83.4%

Minimum 5 values

Value	Count	Frequency (%)
1	3	1.1%
2	5	1.9%
3	7	2.6%
4	2	0.8%
5	2	0.8%

Maximum 5 values

Value	Count	Frequency (%)
2471	1	0.4%
1820	1	0.4%
1349	1	0.4%
1292	1	0.4%
1168	1	0.4%

id
Categorical, Unique

First 5 values
001f6dfaefdbbe31deedb00996c8a87dd90342690611d6...
01a586fca9efeab9f83ccab019962b0887882fac2625fe...
03db1b36296ff895e6494a04d94795b247a78301dec8c0...
04732bec03125a8a17f1191cbd7c6dc675628bbb87125c...
04d34dcdee40a44560907165ab68f8e0ec771c0b94321f...

Last 5 values
fe796f2c60812f6fe96affa216079cf548daa25c3b72ea...
fea23f072675ec89f9b6ffd040777f5ff562c9d7623918...
feb9c97a3f694c22a919d9544c433da92d34d5717b43d5...
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3...
ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5c...

Toggle details

First 5 values

Value	Count	Frequency (%)
001f6dfaefdbbe31deedb00996c8a87dd90342690611d6a0be7fbb19e4b5326c	1	0.4%
01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2	1	0.4%
03db1b36296ff895e6494a04d94795b247a78301dec8c0559bed9924436cc058	1	0.4%
04732bec03125a8a17f1191cbd7c6dc675628bbb87125c4f717b81d9c3bedd6e	1	0.4%
04d34dcdee40a44560907165ab68f8e0ec771c0b94321f688d7a202d73f52673	1	0.4%

Last 5 values

Value	Count	Frequency (%)
ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5cdcea92945d94b62d38	1	0.4%
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6	1	0.4%
feb9c97a3f694c22a919d9544c433da92d34d5717b43d54d88f543aa462958ae	1	0.4%
fea23f072675ec89f9b6ffd040777f5ff562c9d76239180a2e1786f917f3a52f	1	0.4%
fe796f2c60812f6fe96affa216079cf548daa25c3b72ea746d8ad2c25c131d1b	1	0.4%

idade_acima_de_58
Numeric

Distinct count	105
Unique (%)	39.6%
Missing (%)	3.0%
Missing (n)	8
Infinite (%)	0.0%
Infinite (n)	0

Mean	53.91050584
Minimum	1
Maximum	1844
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
Median	27
Q3	57
95-th percentile	182.2
Maximum	1844
Range	1843
Interquartile range	47

Descriptive statistics

Standard deviation	131.1446443
Coef of variation	2.432636131
Kurtosis	138.7295025
Mean	53.91050584
MAD	50.67910188
Skewness	10.65083773
Sum	13855
Variance	17198.91774
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	9	3.4%
5	9	3.4%
17	8	3.0%
3	8	3.0%
6	8	3.0%
11	8	3.0%
12	8	3.0%
1	7	2.6%
4	6	2.3%
8	6	2.3%
Other values (94)	180	67.9%
(Missing)	8	3.0%

Minimum 5 values

Value	Count	Frequency (%)
1	7	2.6%
2	9	3.4%
3	8	3.0%
4	6	2.3%
5	9	3.4%

Maximum 5 values

Value	Count	Frequency (%)
1844	1	0.4%
727	1	0.4%
307	1	0.4%
254	1	0.4%
235	1	0.4%

idade_ate_18
Numeric

Distinct count	13
Unique (%)	4.9%
Missing (%)	78.5%
Missing (n)	208
Infinite (%)	0.0%
Infinite (n)	0

Mean	4.403508772
Minimum	1
Maximum	56
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	2
Q3	5
95-th percentile	10
Maximum	56
Range	55
Interquartile range	4

Descriptive statistics

Standard deviation	7.596661976
Coef of variation	1.725138377
Kurtosis	39.31533632
Mean	4.403508772
MAD	3.527854725
Skewness	5.8714155
Sum	251
Variance	57.70927318
Memory size	14.1 KiB

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
1	16	6.0%
2	13	4.9%
3	10	3.8%
6	5	1.9%
7	3	1.1%
4	2	0.8%
10	2	0.8%
5	2	0.8%
8	1	0.4%
56	1	0.4%
Other values (2)	2	0.8%
(Missing)	208	78.5%

Minimum 5 values

Value	Count	Frequency (%)
1	16	6.0%
2	13	4.9%
3	10	3.8%
4	2	0.8%
5	2	0.8%

Maximum 5 values

Value	Count	Frequency (%)
56	1	0.4%
17	1	0.4%
10	2	0.8%
9	1	0.4%
8	1	0.4%

idade_de_19_a_23
Numeric

Distinct count	43
Unique (%)	16.2%
Missing (%)	28.7%
Missing (n)	76
Infinite (%)	0.0%
Infinite (n)	0

Mean	15.14285714
Minimum	1
Maximum	643
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
Median	6
Q3	16
95-th percentile	37.8
Maximum	643
Range	642
Interquartile range	13

Descriptive statistics

Standard deviation	48.70171602
Coef of variation	3.216151058
Kurtosis	148.9475845
Mean	15.14285714
MAD	14.88737717
Skewness	11.64694624
Sum	2862
Variance	2371.857143
Memory size	14.1 KiB

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
1	27	10.2%
2	19	7.2%
3	15	5.7%
4	13	4.9%
6	12	4.5%
5	12	4.5%
7	10	3.8%
10	8	3.0%
18	6	2.3%
19	5	1.9%
Other values (32)	62	23.4%
(Missing)	76	28.7%

Minimum 5 values

Value	Count	Frequency (%)
1	27	10.2%
2	19	7.2%
3	15	5.7%
4	13	4.9%
5	12	4.5%

Maximum 5 values

Value	Count	Frequency (%)
643	1	0.4%
139	1	0.4%
102	1	0.4%
65	1	0.4%
57	1	0.4%

idade_de_24_a_28
Highly correlated

This variable is highly correlated with idade_de_19_a_23 and should be ignored for analysis

Correlation	0.9391201682

idade_de_29_a_33
Numeric

Distinct count	117
Unique (%)	44.2%
Missing (%)	0.4%
Missing (n)	1
Infinite (%)	0.0%
Infinite (n)	0

Mean	61.93560606
Minimum	2
Maximum	749
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2
5-th percentile	8
Q1	23.75
Median	40
Q3	70.25
95-th percentile	171.95
Maximum	749
Range	747
Interquartile range	46.5

Descriptive statistics

Standard deviation	81.47251993
Coef of variation	1.315439133
Kurtosis	29.98701438
Mean	61.93560606
MAD	44.9774449
Skewness	4.724876315
Sum	16351
Variance	6637.771503
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32	7	2.6%
31	7	2.6%
11	7	2.6%
40	6	2.3%
22	6	2.3%
10	6	2.3%
27	6	2.3%
29	5	1.9%
25	5	1.9%
45	5	1.9%
Other values (106)	204	77.0%

Minimum 5 values

Value	Count	Frequency (%)
2	2	0.8%
3	1	0.4%
4	1	0.4%
5	1	0.4%
6	2	0.8%

Maximum 5 values

Value	Count	Frequency (%)
749	1	0.4%
603	1	0.4%
517	1	0.4%
357	1	0.4%
325	1	0.4%

idade_de_34_a_38
Numeric

Distinct count	123
Unique (%)	46.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	77.0754717
Minimum	1
Maximum	682
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	12
Q1	28
Median	45
Q3	102
95-th percentile	246
Maximum	682
Range	681
Interquartile range	74

Descriptive statistics

Standard deviation	85.41096043
Coef of variation	1.1081471
Kurtosis	14.19407178
Mean	77.0754717
MAD	55.99629761
Skewness	3.180956646
Sum	20425
Variance	7295.032161
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 1. 18.5 48.5 130. 189.5 371.5 682. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
28	8	3.0%
21	7	2.6%
27	6	2.3%
41	6	2.3%
33	6	2.3%
42	6	2.3%
34	6	2.3%
37	5	1.9%
22	5	1.9%
23	5	1.9%
Other values (113)	205	77.4%

Minimum 5 values

Value	Count	Frequency (%)
1	1	0.4%
3	2	0.8%
6	1	0.4%
9	2	0.8%
10	3	1.1%

Maximum 5 values

Value	Count	Frequency (%)
682	1	0.4%
535	1	0.4%
444	1	0.4%
375	1	0.4%
368	1	0.4%

idade_de_39_a_43
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation	0.9147291585

idade_de_44_a_48
Highly correlated

This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis

Correlation	0.9376949593

idade_de_49_a_53
Numeric

Distinct count	116
Unique (%)	43.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	53.50188679
Minimum	1
Maximum	532
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	5.2
Q1	19
Median	37
Q3	64
95-th percentile	163
Maximum	532
Range	531
Interquartile range	45

Descriptive statistics

Standard deviation	58.86696124
Coef of variation	1.100278229
Kurtosis	18.51098245
Mean	53.50188679
MAD	37.91572802
Skewness	3.374100194
Sum	14178
Variance	3465.319125
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 1. 60.5 123.5 257. 532. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
14	9	3.4%
21	6	2.3%
22	6	2.3%
31	6	2.3%
15	6	2.3%
30	6	2.3%
28	6	2.3%
7	6	2.3%
16	5	1.9%
8	5	1.9%
Other values (106)	204	77.0%

Minimum 5 values

Value	Count	Frequency (%)
1	2	0.8%
2	2	0.8%
3	2	0.8%
4	4	1.5%
5	4	1.5%

Maximum 5 values

Value	Count	Frequency (%)
532	1	0.4%
315	1	0.4%
266	1	0.4%
248	1	0.4%
235	1	0.4%

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_acima_de_58 and should be ignored for analysis

Correlation	0.9500453674

idade_emp_cat
Categorical

Distinct count	6
Unique (%)	2.3%
Missing (%)	0.0%
Missing (n)	0

> 20	176
15 a 20	33
5 a 10	27
Other values (3)	29

Toggle details

Common values
Composition

Value	Count	Frequency (%)
> 20	176	66.4%
15 a 20	33	12.5%
5 a 10	27	10.2%
10 a 15	21	7.9%
1 a 5	7	2.6%
<= 1	1	0.4%

Max length	7
Mean length	4.841509434
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

idade_empresa_anos
Numeric

Distinct count	214
Unique (%)	80.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	27.76250194
Minimum	0.7616438356
Maximum	51.80821918
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.7616438356
5-th percentile	6.068493151
Q1	17.63835616
Median	24.0739726
Q3	43.8
95-th percentile	47.15780822
Maximum	51.80821918
Range	51.04657534
Interquartile range	26.16164384

Descriptive statistics

Standard deviation	14.11960273
Coef of variation	0.5085853846
Kurtosis	-1.333726542
Mean	27.76250194
MAD	12.56690579
Skewness	0.02010867161
Sum	7357.063014
Variance	199.3631811
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0.76164384 7.58767123 21.78630137 21.88356164 43.43835616 ... 43.85342466 43.85616438 43.87123288 43.94794521 51.80821918], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
43.85479452	11	4.2%
21.83561644	9	3.4%
21.83287671	6	2.3%
43.86575342	6	2.3%
43.87671233	5	1.9%
43.86849315	4	1.5%
43.84657534	4	1.5%
43.83287671	3	1.1%
21.81643836	3	1.1%
43.8	3	1.1%
Other values (204)	211	79.6%

Minimum 5 values

Value	Count	Frequency (%)
0.7616438356	1	0.4%
1.002739726	1	0.4%
2.498630137	1	0.4%
2.6	1	0.4%
2.95890411	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
51.80821918	1	0.4%
51.49863014	1	0.4%
51.33424658	1	0.4%
50.92876712	1	0.4%
50.66027397	1	0.4%

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation	0.990757127

idade_maxima_socios
Numeric

Distinct count	50
Unique (%)	18.9%
Missing (%)	64.9%
Missing (n)	172
Infinite (%)	0.0%
Infinite (n)	0

Mean	54.96774194
Minimum	4
Maximum	90
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4
5-th percentile	31.6
Q1	45
Median	54
Q3	66
95-th percentile	79.4
Maximum	90
Range	86
Interquartile range	21

Descriptive statistics

Standard deviation	15.46626878
Coef of variation	0.2813699132
Kurtosis	0.2465950917
Mean	54.96774194
MAD	12.35449185
Skewness	-0.2249164359
Sum	5112
Variance	239.2054698
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
54	5	1.9%
50	4	1.5%
66	4	1.5%
49	4	1.5%
51	3	1.1%
33	3	1.1%
65	3	1.1%
47	3	1.1%
72	3	1.1%
55	3	1.1%
Other values (39)	58	21.9%
(Missing)	172	64.9%

Minimum 5 values

Value	Count	Frequency (%)
4	1	0.4%
27	1	0.4%
29	1	0.4%
30	1	0.4%
31	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
90	1	0.4%
86	1	0.4%
84	1	0.4%
82	1	0.4%
80	1	0.4%

idade_media_coligadas
Numeric

Distinct count	77
Unique (%)	29.1%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	174.0541455
Minimum	2.3
Maximum	498.9666667
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2.3
5-th percentile	24.475
Q1	102.8291667
Median	156.6618056
Q3	243.9458333
95-th percentile	382.3583333
Maximum	498.9666667
Range	496.6666667
Interquartile range	141.1166667

Descriptive statistics

Standard deviation	108.4789161
Coef of variation	0.6232481036
Kurtosis	0.7833237045
Mean	174.0541455
MAD	85.83890719
Skewness	0.8317969626
Sum	13228.11506
Variance	11767.67524
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
139.6222222	1	0.4%
358.9416667	1	0.4%
495.95	1	0.4%
16.8	1	0.4%
44.06666667	1	0.4%
276.6333333	1	0.4%
21.2	1	0.4%
102.8666667	1	0.4%
116.3666667	1	0.4%
243.8166667	1	0.4%
Other values (66)	66	24.9%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
2.3	1	0.4%
5.8	1	0.4%
16.8	1	0.4%
21.2	1	0.4%
25.56666667	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
498.9666667	1	0.4%
495.95	1	0.4%
408.4666667	1	0.4%
389.9833333	1	0.4%
379.8166667	1	0.4%

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation	0.9928275535

idade_media_coligadas_baixadas
Categorical

Distinct count	2
Unique (%)	0.8%
Missing (%)	99.6%
Missing (n)	264

190.9	1
(Missing)	264

Toggle details

Common values
Composition

Value	Count	Frequency (%)
190.9	1	0.4%
(Missing)	264	99.6%

Max length	5
Mean length	3.00754717
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

idade_media_socios
Numeric

Distinct count	63
Unique (%)	23.8%
Missing (%)	64.9%
Missing (n)	172
Infinite (%)	0.0%
Infinite (n)	0

Mean	49.94940271
Minimum	4
Maximum	90
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4
5-th percentile	29.4
Q1	41
Median	50
Q3	61
95-th percentile	70.3
Maximum	90
Range	86
Interquartile range	20

Descriptive statistics

Standard deviation	13.80293694
Coef of variation	0.2763383782
Kurtosis	0.5110116608
Mean	49.94940271
MAD	11.17281318
Skewness	-0.1185136621
Sum	4645.294452
Variance	190.5210681
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
64	3	1.1%
63	3	1.1%
55	3	1.1%
47	3	1.1%
33	3	1.1%
50	3	1.1%
52	3	1.1%
69	2	0.8%
46.66666667	2	0.8%
64.5	2	0.8%
Other values (52)	66	24.9%
(Missing)	172	64.9%

Minimum 5 values

Value	Count	Frequency (%)
4	1	0.4%
27	2	0.8%
28	1	0.4%
28.5	1	0.4%
30	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
90	1	0.4%
75.66666667	1	0.4%
72	1	0.4%
71	1	0.4%
70.75	1	0.4%

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation	1

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation	0.9030093563

max_faturamento_est_coligados
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation	0.9484709664

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation	0.9515331439

max_filiais_coligados
Numeric

Distinct count	15
Unique (%)	5.7%
Missing (%)	86.4%
Missing (n)	229
Infinite (%)	0.0%
Infinite (n)	0

Mean	40.58333333
Minimum	1
Maximum	666
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1.75
Median	4
Q3	7
95-th percentile	178.25
Maximum	666
Range	665
Interquartile range	5.25

Descriptive statistics

Standard deviation	120.6691758
Coef of variation	2.973367783
Kurtosis	21.72829598
Mean	40.58333333
MAD	61.58333333
Skewness	4.4449895
Sum	1461
Variance	14561.05
Memory size	14.1 KiB

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
1	9	3.4%
4	4	1.5%
3	4	1.5%
2	4	1.5%
7	3	1.1%
6	3	1.1%
5	2	0.8%
275	1	0.4%
666	1	0.4%
146	1	0.4%
Other values (4)	4	1.5%
(Missing)	229	86.4%

Minimum 5 values

Value	Count	Frequency (%)
1	9	3.4%
2	4	1.5%
3	4	1.5%
4	4	1.5%
5	2	0.8%

Maximum 5 values

Value	Count	Frequency (%)
666	1	0.4%
275	1	0.4%
146	1	0.4%
140	1	0.4%
76	1	0.4%

max_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_filiais_coligados and should be ignored for analysis

Correlation	0.9312487825

max_meses_servicos
Numeric

Distinct count	228
Unique (%)	86.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	472.16
Minimum	6
Maximum	5099.066667
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	6
5-th percentile	46.49333333
Q1	251.5
Median	414.3333333
Q3	521.3666667
95-th percentile	641.3066667
Maximum	5099.066667
Range	5093.066667
Interquartile range	269.8666667

Descriptive statistics

Standard deviation	729.1793112
Coef of variation	1.544347914
Kurtosis	34.67675123
Mean	472.16
MAD	268.1125031
Skewness	5.815251087
Sum	125122.4
Variance	531702.4679
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 6. 251.51666667 268.21666667 481.31666667 506.15 508.08333333 596.41666667 693.5 5099.06666667], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
5099.066667	6	2.3%
507.2	5	1.9%
470.6666667	5	1.9%
265.6333333	5	1.9%
521.3666667	4	1.5%
265.6666667	4	1.5%
481.8333333	3	1.1%
495.0333333	3	1.1%
113.5333333	2	0.8%
123.6333333	2	0.8%
Other values (218)	226	85.3%

Minimum 5 values

Value	Count	Frequency (%)
6	1	0.4%
13.06666667	1	0.4%
26.23333333	1	0.4%
29.3	1	0.4%
30.33333333	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
5099.066667	6	2.3%
804.4333333	1	0.4%
801.3666667	1	0.4%
707.3666667	1	0.4%
679.6333333	1	0.4%

max_meses_servicos_all
Numeric

Distinct count	154
Unique (%)	58.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2134.504151
Minimum	13.06666667
Maximum	5099.066667
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	13.06666667
5-th percentile	53.44666667
Q1	257.3333333
Median	490.4333333
Q3	5014.966667
95-th percentile	5014.966667
Maximum	5099.066667
Range	5086
Interquartile range	4757.633333

Descriptive statistics

Standard deviation	2311.318392
Coef of variation	1.082836213
Kurtosis	-1.797733588
Mean	2134.504151
MAD	2245.220169
Skewness	0.4491050719
Sum	565643.6
Variance	5342192.709
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 13.06666667 251.51666667 268.21666667 579.1 662.26666667 2847.3 5039.83333333 5099.06666667], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
5014.966667	91	34.3%
5099.066667	6	2.3%
5064.7	5	1.9%
265.6666667	4	1.5%
265.6333333	4	1.5%
481.8333333	2	0.8%
373.2666667	2	0.8%
50.6	2	0.8%
387.4333333	2	0.8%
113.5333333	2	0.8%
Other values (144)	145	54.7%

Minimum 5 values

Value	Count	Frequency (%)
13.06666667	1	0.4%
26.23333333	1	0.4%
29.3	1	0.4%
29.36666667	1	0.4%
30.4	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
5099.066667	6	2.3%
5065.733333	1	0.4%
5064.7	5	1.9%
5014.966667	91	34.3%
679.6333333	1	0.4%

max_vl_folha_coligados
Numeric

Distinct count	56
Unique (%)	21.1%
Missing (%)	78.1%
Missing (n)	207
Infinite (%)	0.0%
Infinite (n)	0

Mean	28700451.66
Minimum	0
Maximum	207712510
Zeros (%)	0.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	141153.84
Q1	819104.4
Median	7871644.75
Q3	31666885.5
95-th percentile	165981456
Maximum	207712510
Range	207712510
Interquartile range	30847781.1

Descriptive statistics

Standard deviation	50411040.49
Coef of variation	1.756454605
Kurtosis	5.42770491
Mean	28700451.66
MAD	33899732.93
Skewness	2.437294092
Sum	1664626196
Variance	2.541273004e+15
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
247276.8	3	1.1%
370915.2	2	0.8%
13002638	1	0.4%
123432340	1	0.4%
75130936	1	0.4%
8531050	1	0.4%
33959348	1	0.4%
43953452	1	0.4%
8242560	1	0.4%
4224312	1	0.4%
Other values (45)	45	17.0%
(Missing)	207	78.1%

Minimum 5 values

Value	Count	Frequency (%)
0	1	0.4%
61819.2	1	0.4%
123638.4	1	0.4%
144244.8	1	0.4%
185457.6	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
207712510	1	0.4%
203920930	1	0.4%
171568880	1	0.4%
164995440	1	0.4%
123432340	1	0.4%

max_vl_folha_coligados_gp
Numeric

Distinct count	58
Unique (%)	21.9%
Missing (%)	77.7%
Missing (n)	206
Infinite (%)	0.0%
Infinite (n)	0

Mean	75770780.64
Minimum	61819.2
Maximum	1390128400
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	61819.2
5-th percentile	181336.32
Q1	1112745.6
Median	8242560
Q3	41161284
95-th percentile	285464576
Maximum	1390128400
Range	1390066581
Interquartile range	40048538.4

Descriptive statistics

Standard deviation	228286559.6
Coef of variation	3.012857433
Kurtosis	22.00973326
Mean	75770780.64
MAD	105783786.2
Skewness	4.554564643
Sum	4470476058
Variance	5.211475331e+16
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
247276.8	3	1.1%
6820718.5	1	0.4%
123432340	1	0.4%
8531050	1	0.4%
43953452	1	0.4%
8242560	1	0.4%
783043.2	1	0.4%
288489.6	1	0.4%
123617790	1	0.4%
44736496	1	0.4%
Other values (47)	47	17.7%
(Missing)	206	77.7%

Minimum 5 values

Value	Count	Frequency (%)
61819.2	1	0.4%
123638.4	1	0.4%
144244.8	1	0.4%
185457.6	1	0.4%
247276.8	3	1.1%

Maximum 5 values

Value	Count	Frequency (%)
1390128400	1	0.4%
898068100	1	0.4%
678300860	1	0.4%
241816100	1	0.4%
177421100	1	0.4%

media_faturamento_est_coligados
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation	0.9075319591

media_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation	0.9465645673

media_filiais_coligados
Numeric

Distinct count	20
Unique (%)	7.5%
Missing (%)	86.4%
Missing (n)	229
Infinite (%)	0.0%
Infinite (n)	0

Mean	8.003972262
Minimum	1
Maximum	63
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1.5
Median	2.1
Q3	4.125
95-th percentile	41.125
Maximum	63
Range	62
Interquartile range	2.625

Descriptive statistics

Standard deviation	14.36052137
Coef of variation	1.794174305
Kurtosis	7.114313903
Mean	8.003972262
MAD	9.268296501
Skewness	2.722577445
Sum	288.1430014
Variance	206.2245741
Memory size	14.1 KiB

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
1	9	3.4%
2	8	3.0%
4	3	1.1%
2.2	1	0.4%
10	1	0.4%
25	1	0.4%
2.5	1	0.4%
63	1	0.4%
6	1	0.4%
1.666666667	1	0.4%
Other values (9)	9	3.4%
(Missing)	229	86.4%

Minimum 5 values

Value	Count	Frequency (%)
1	9	3.4%
1.666666667	1	0.4%
2	8	3.0%
2.2	1	0.4%
2.363636364	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
63	1	0.4%
49	1	0.4%
38.5	1	0.4%
25	1	0.4%
24	1	0.4%

media_funcionarios_coligados_gp
Numeric

Distinct count	56
Unique (%)	21.1%
Missing (%)	76.2%
Missing (n)	202
Infinite (%)	0.0%
Infinite (n)	0

Mean	243.245227
Minimum	0
Maximum	4398.611111
Zeros (%)	1.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0.1
Q1	7.666666667
Median	45
Q3	150
95-th percentile	846.658
Maximum	4398.611111
Range	4398.611111
Interquartile range	142.3333333

Descriptive statistics

Standard deviation	652.2327083
Coef of variation	2.681379266
Kurtosis	28.05675891
Mean	243.245227
MAD	311.8019896
Skewness	4.962912511
Sum	15324.4493
Variance	425407.5058
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	4	1.5%
0	4	1.5%
10	2	0.8%
3	2	0.8%
25	1	0.4%
45	1	0.4%
119	1	0.4%
28.25	1	0.4%
77	1	0.4%
37	1	0.4%
Other values (45)	45	17.0%
(Missing)	202	76.2%

Minimum 5 values

Value	Count	Frequency (%)
0	4	1.5%
1	1	0.4%
2	1	0.4%
3	2	0.8%
4	4	1.5%

Maximum 5 values

Value	Count	Frequency (%)
4398.611111	1	0.4%
2112	1	0.4%
1878.333333	1	0.4%
851.4333333	1	0.4%
803.68	1	0.4%

media_meses_servicos
Numeric

Distinct count	265
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	129.43489
Minimum	5.947005208
Maximum	353.9549383
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	5.947005208
5-th percentile	22.16216747
Q1	58.73533333
Median	138.3858912
Q3	182.0918301
95-th percentile	234.5757388
Maximum	353.9549383
Range	348.0079331
Interquartile range	123.3564967

Descriptive statistics

Standard deviation	73.44083954
Coef of variation	0.5673960053
Kurtosis	-0.6431313459
Mean	129.43489
MAD	62.156147
Skewness	0.1463746749
Sum	34300.24586
Variance	5393.556912
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 5.94700521 71.14189247 131.75648398 230.94920855 353.95493827], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
47.86570697	1	0.4%
146.8411438	1	0.4%
152.2654971	1	0.4%
30.82928647	1	0.4%
223.3868766	1	0.4%
235.2654229	1	0.4%
160.5006369	1	0.4%
58.73533333	1	0.4%
99.72819549	1	0.4%
121.8192187	1	0.4%
Other values (255)	255	96.2%

Minimum 5 values

Value	Count	Frequency (%)
5.947005208	1	0.4%
10.96567901	1	0.4%
11.98393574	1	0.4%
14.42028986	1	0.4%
15.14791667	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
353.9549383	1	0.4%
319.0152482	1	0.4%
313.4891775	1	0.4%
310.8166667	1	0.4%
288.7471564	1	0.4%

media_meses_servicos_all
Numeric

Distinct count	265
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	120.2838588
Minimum	6.115453384
Maximum	576.6240637
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	6.115453384
5-th percentile	16.11094299
Q1	39.68535147
Median	110.7311828
Q3	173.4749593
95-th percentile	260.4524049
Maximum	576.6240637
Range	570.5086103
Interquartile range	133.7896079

Descriptive statistics

Standard deviation	92.93103827
Coef of variation	0.7725977467
Kurtosis	3.980982333
Mean	120.2838588
MAD	71.72502269
Skewness	1.453669429
Sum	31875.22258
Variance	8636.177875
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 6.11545338 40.25856594 226.94763241 288.83190072 576.62406367], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
295.4055381	1	0.4%
43.00790988	1	0.4%
43.70350877	1	0.4%
177.7679012	1	0.4%
10.88125	1	0.4%
35.87798085	1	0.4%
192.4009315	1	0.4%
93.25028011	1	0.4%
137.1910522	1	0.4%
30.17237164	1	0.4%
Other values (255)	255	96.2%

Minimum 5 values

Value	Count	Frequency (%)
6.115453384	1	0.4%
8.896975875	1	0.4%
8.910264947	1	0.4%
9.274385965	1	0.4%
10.88125	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
576.6240637	1	0.4%
552.7651578	1	0.4%
519.2097977	1	0.4%
367.717433	1	0.4%
361.3688113	1	0.4%

media_vl_folha_coligados
Numeric

Distinct count	57
Unique (%)	21.5%
Missing (%)	78.1%
Missing (n)	207
Infinite (%)	0.0%
Infinite (n)	0

Mean	9142780.315
Minimum	0
Maximum	123432336
Zeros (%)	0.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	141153.8371
Q1	489402
Median	4234615.3
Q3	10169258.7
95-th percentile	26650521.97
Maximum	123432336
Range	123432336
Interquartile range	9679856.695

Descriptive statistics

Standard deviation	17729689.14
Coef of variation	1.939201045
Kurtosis	30.81501375
Mean	9142780.315
MAD	9466681.82
Skewness	5.006155602
Sum	530281258.2
Variance	3.143418771e+14
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
247276.7969	3	1.1%
597585.625	1	0.4%
216367.1953	1	0.4%
4244918.6	1	0.4%
4224312	1	0.4%
13991745.79	1	0.4%
2720044.75	1	0.4%
5472716.419	1	0.4%
61819.19922	1	0.4%
36695875.81	1	0.4%
Other values (46)	46	17.4%
(Missing)	207	78.1%

Minimum 5 values

Value	Count	Frequency (%)
0	1	0.4%
61819.19922	1	0.4%
123638.3984	1	0.4%
144244.7969	1	0.4%
185457.5938	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
123432336	1	0.4%
38369116	1	0.4%
36695875.81	1	0.4%
24877812.46	1	0.4%
24383431.91	1	0.4%

media_vl_folha_coligados_gp
Numeric

Distinct count	58
Unique (%)	21.9%
Missing (%)	77.7%
Missing (n)	206
Infinite (%)	0.0%
Infinite (n)	0

Mean	14371416.38
Minimum	61819.19922
Maximum	123432336
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	61819.19922
5-th percentile	181336.3141
Q1	723799.7866
Median	4718865.566
Q3	11292306.88
95-th percentile	63808925.32
Maximum	123432336
Range	123370516.8
Interquartile range	10568507.09

Descriptive statistics

Standard deviation	25761432.24
Coef of variation	1.792546507
Kurtosis	8.032650745
Mean	14371416.38
MAD	16632802.19
Skewness	2.787974974
Sum	847913566.5
Variance	6.636513912e+14
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
247276.7969	3	1.1%
20716300.79	1	0.4%
8531050	1	0.4%
783043.1875	1	0.4%
18126763.12	1	0.4%
216367.1953	1	0.4%
61812331.12	1	0.4%
2720044.75	1	0.4%
61819.19922	1	0.4%
8798932.779	1	0.4%
Other values (47)	47	17.7%
(Missing)	206	77.7%

Minimum 5 values

Value	Count	Frequency (%)
61819.19922	1	0.4%
123638.3984	1	0.4%
144244.7969	1	0.4%
185457.5938	1	0.4%
216367.1953	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
123432336	1	0.4%
110241817.5	1	0.4%
81778273.11	1	0.4%
61812331.12	1	0.4%
52856273.81	1	0.4%

meses_ultima_contratacaco
Numeric

Distinct count	137
Unique (%)	51.7%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	19.38792453
Minimum	1.966666667
Maximum	112.1666667
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.966666667
5-th percentile	2.066666667
Q1	2.933333333
Median	23.2
Q3	27.9
95-th percentile	42.51333333
Maximum	112.1666667
Range	110.2
Interquartile range	24.96666667

Descriptive statistics

Standard deviation	16.07359668
Coef of variation	0.8290519522
Kurtosis	4.60609407
Mean	19.38792453
MAD	12.8650566
Skewness	1.295618532
Sum	5137.8
Variance	258.3605102
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 1.96666667 3.06666667 4.98333333 22.18333333 23.18333333 ... 25.06666667 25.25 31.56666667 46.53333333 112.16666667], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2.933333333	16	6.0%
23.2	13	4.9%
24.2	10	3.8%
2.066666667	10	3.8%
2.3	7	2.6%
30.33333333	6	2.3%
2.533333333	6	2.3%
2.2	5	1.9%
2.033333333	5	1.9%
28.3	5	1.9%
Other values (127)	182	68.7%

Minimum 5 values

Value	Count	Frequency (%)
1.966666667	3	1.1%
2	1	0.4%
2.033333333	5	1.9%
2.066666667	10	3.8%
2.166666667	2	0.8%

Maximum 5 values

Value	Count	Frequency (%)
112.1666667	1	0.4%
88.16666667	1	0.4%
70.86666667	1	0.4%
68.9	1	0.4%
65.83333333	1	0.4%

min_faturamento_est_coligados
Numeric

Distinct count	26
Unique (%)	9.8%
Missing (%)	72.1%
Missing (n)	191
Infinite (%)	0.0%
Infinite (n)	0

Mean	1901396.8
Minimum	50000
Maximum	32506596
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	50000
5-th percentile	123638.4
Q1	210000
Median	210000
Q3	494553.6
95-th percentile	16595879.4
Maximum	32506596
Range	32456596
Interquartile range	284553.6

Descriptive statistics

Standard deviation	5720661.001
Coef of variation	3.008662369
Kurtosis	15.21235622
Mean	1901396.8
MAD	2850976.173
Skewness	3.898271231
Sum	140703363.2
Variance	3.272596229e+13
Memory size	14.1 KiB

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
210000	39	14.7%
123638.4	8	3.0%
494553.6	3	1.1%
618192	2	0.8%
930000	2	0.8%
21327624	1	0.4%
1195171.2	1	0.4%
3008534.5	1	0.4%
32506596	1	0.4%
16433604	1	0.4%
Other values (15)	15	5.7%
(Missing)	191	72.1%

Minimum 5 values

Value	Count	Frequency (%)
50000	1	0.4%
123638.4	8	3.0%
164851.2	1	0.4%
185457.6	1	0.4%
206064	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
32506596	1	0.4%
23182200	1	0.4%
21327624	1	0.4%
16897248	1	0.4%
16433604	1	0.4%

min_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation	0.9844779291

min_filiais_coligados
Numeric

Distinct count	8
Unique (%)	3.0%
Missing (%)	86.4%
Missing (n)	229
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.972222222
Minimum	1
Maximum	49
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	2
95-th percentile	5.25
Maximum	49
Range	48
Interquartile range	1

Descriptive statistics

Standard deviation	7.983862692
Coef of variation	2.686159411
Kurtosis	34.19743454
Mean	2.972222222
MAD	2.899691358
Skewness	5.787633327
Sum	107
Variance	63.74206349
Memory size	14.1 KiB

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	24	9.1%
2	5	1.9%
3	3	1.1%
49	1	0.4%
4	1	0.4%
6	1	0.4%
5	1	0.4%
(Missing)	229	86.4%

Minimum 5 values

Value	Count	Frequency (%)
1	24	9.1%
2	5	1.9%
3	3	1.1%
4	1	0.4%
5	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
49	1	0.4%
6	1	0.4%
5	1	0.4%
4	1	0.4%
3	3	1.1%

min_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with min_filiais_coligados and should be ignored for analysis

Correlation	0.916066893

min_meses_servicos
Highly correlated

This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis

Correlation	0.9567491686

min_meses_servicos_all
Numeric

Distinct count	125
Unique (%)	47.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.331194969
Minimum	-11.7
Maximum	66.93333333
Zeros (%)	7.2%

Toggle details

Quantile statistics

Minimum	-11.7
5-th percentile	-6.1
Q1	-0.6333333333
Median	0
Q3	1.666666667
95-th percentile	10.87333333
Maximum	66.93333333
Range	78.63333333
Interquartile range	2.3

Descriptive statistics

Standard deviation	7.099983375
Coef of variation	5.333541324
Kurtosis	33.65754482
Mean	1.331194969
MAD	3.590815237
Skewness	4.578945101
Sum	352.7666667
Variance	50.40976393
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[-1.17000000e+01 -1.15000000e+00 -7.50000000e-01 -5.00000000e-02 6.66666667e-02 9.66666667e-01 1.05000000e+00 3.13333333e+00 1.28500000e+01 6.69333333e+01], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	19	7.2%
1	14	5.3%
-0.5333333333	9	3.4%
-0.03333333333	8	3.0%
-0.7333333333	6	2.3%
0.2	6	2.3%
2.033333333	5	1.9%
-0.4	5	1.9%
8.133333333	5	1.9%
3.033333333	4	1.5%
Other values (115)	184	69.4%

Minimum 5 values

Value	Count	Frequency (%)
-11.7	1	0.4%
-11.2	2	0.8%
-11.16666667	1	0.4%
-10.16666667	1	0.4%
-9.833333333	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
66.93333333	1	0.4%
44.2	1	0.4%
27.7	1	0.4%
27.5	1	0.4%
26.7	1	0.4%

min_vl_folha_coligados
Highly correlated

This variable is highly correlated with min_funcionarios_coligados_gp and should be ignored for analysis

Correlation	0.9989755332

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis

Correlation	0.9991732114

natureza_juridica_macro
Categorical

Distinct count	4
Unique (%)	1.5%
Missing (%)	0.0%
Missing (n)	0

OUTROS	128
ENTIDADES EMPRESARIAIS	73
ADMINISTRACAO PUBLICA	47

Toggle details

Common values
Composition

Value	Count	Frequency (%)
OUTROS	128	48.3%
ENTIDADES EMPRESARIAIS	73	27.5%
ADMINISTRACAO PUBLICA	47	17.7%
ENTIDADES SEM FINS LUCRATIVOS	17	6.4%

Max length	29
Mean length	14.54339623
Min length	6
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_divisao
Categorical

Distinct count	26
Unique (%)	9.8%
Missing (%)	0.0%
Missing (n)	0

ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	150
EDUCACAO	22
SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS	18
Other values (23)	75

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	150	56.6%
EDUCACAO	22	8.3%
SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS	18	6.8%
ATIVIDADES DE ATENCAO A SAUDE HUMANA	12	4.5%
TRANSPORTE TERRESTRE	12	4.5%
SELECAO AGENCIAMENTO E LOCACAO DE MAO DE OBRA	6	2.3%
SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS	4	1.5%
ALIMENTACAO	4	1.5%
ATIVIDADES DE VIGILANCIA SEGURANCA E INVESTIGACAO	4	1.5%
SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS	4	1.5%
Other values (16)	29	10.9%

Max length	120
Mean length	43.50943396
Min length	8
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_meso_regiao
Categorical

Distinct count	20
Unique (%)	7.5%
Missing (%)	9.1%
Missing (n)	24

NORTE MARANHENSE	41
CENTRO AMAZONENSE	39
CENTRO NORTE PIAUIENSE	31
Other values (16)	130
(Missing)	24

Toggle details

Common values
Composition

Value	Count	Frequency (%)
NORTE MARANHENSE	41	15.5%
CENTRO AMAZONENSE	39	14.7%
CENTRO NORTE PIAUIENSE	31	11.7%
LESTE POTIGUAR	23	8.7%
VALE DO ACRE	21	7.9%
OESTE POTIGUAR	13	4.9%
SUDESTE PIAUIENSE	11	4.2%
CENTRO MARANHENSE	11	4.2%
OESTE MARANHENSE	10	3.8%
AGRESTE POTIGUAR	8	3.0%
Other values (9)	33	12.5%
(Missing)	24	9.1%

Max length	22
Mean length	15.16226415
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_micro_regiao
Categorical

Distinct count	57
Unique (%)	21.5%
Missing (%)	9.1%
Missing (n)	24

MANAUS	38
AGLOMERACAO URBANA DE SAO LUIS	32
TERESINA	21
Other values (53)	150
(Missing)	24

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MANAUS	38	14.3%
AGLOMERACAO URBANA DE SAO LUIS	32	12.1%
TERESINA	21	7.9%
RIO BRANCO	19	7.2%
NATAL	18	6.8%
MEDIO MEARIM	6	2.3%
PINDARE	6	2.3%
PICOS	6	2.3%
ALTO MEDIO CANINDE	5	1.9%
CAMPO MAIOR	5	1.9%
Other values (46)	85	32.1%
(Missing)	24	9.1%

Max length	30
Mean length	12.34716981
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_segmento
Categorical

Distinct count	13
Unique (%)	4.9%
Missing (%)	0.0%
Missing (n)	0

ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	150
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES	35
EDUCACAO	22
Other values (10)	58

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	150	56.6%
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES	35	13.2%
EDUCACAO	22	8.3%
SAUDE HUMANA E SERVICOS SOCIAIS	14	5.3%
TRANSPORTE ARMAZENAGEM E CORREIO	14	5.3%
AGUA ESGOTO ATIVIDADES DE GESTAO DE RESIDUOS E DESCONTAMINACAO	5	1.9%
ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS RELACIONADOS	5	1.9%
ALOJAMENTO E ALIMENTACAO	5	1.9%
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS	5	1.9%
OUTRAS ATIVIDADES DE SERVICOS	4	1.5%
Other values (3)	6	2.3%

Max length	62
Mean length	42.62641509
Min length	8
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nu_meses_rescencia
Numeric

Distinct count	12
Unique (%)	4.5%
Missing (%)	0.4%
Missing (n)	1
Infinite (%)	0.0%
Infinite (n)	0

Mean	24.73863636
Minimum	9
Maximum	49
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	9
5-th percentile	22
Q1	23
Median	23
Q3	23
95-th percentile	48
Maximum	49
Range	40
Interquartile range	0

Descriptive statistics

Standard deviation	6.241333431
Coef of variation	0.2522909242
Kurtosis	9.907271187
Mean	24.73863636
MAD	3.192493113
Skewness	3.29038472
Sum	6531
Variance	38.954243
Memory size	14.1 KiB

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
23	205	77.4%
48	15	5.7%
26	13	4.9%
22	12	4.5%
24	7	2.6%
27	4	1.5%
21	3	1.1%
25	2	0.8%
9	1	0.4%
47	1	0.4%

Minimum 5 values

Value	Count	Frequency (%)
9	1	0.4%
21	3	1.1%
22	12	4.5%
23	205	77.4%
24	7	2.6%

Maximum 5 values

Value	Count	Frequency (%)
49	1	0.4%
48	15	5.7%
47	1	0.4%
27	4	1.5%
26	13	4.9%

percent_func_genero_fem
Numeric

Distinct count	261
Unique (%)	98.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	52.97943396
Minimum	0.36
Maximum	86.06
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.36
5-th percentile	13.274
Q1	43.38
Median	57.51
Q3	67.71
95-th percentile	76.994
Maximum	86.06
Range	85.7
Interquartile range	24.33

Descriptive statistics

Standard deviation	19.04481282
Coef of variation	0.3594755814
Kurtosis	0.1213098667
Mean	52.97943396
MAD	15.19650267
Skewness	-0.8547835709
Sum	14039.55
Variance	362.7048955
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0.36 30.935 47.245 73.815 86.06 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
63.38	2	0.8%
72.93	2	0.8%
69.21	2	0.8%
50	2	0.8%
68.02	1	0.4%
49.35	1	0.4%
52.31	1	0.4%
68.63	1	0.4%
63.36	1	0.4%
74.03	1	0.4%
Other values (251)	251	94.7%

Minimum 5 values

Value	Count	Frequency (%)
0.36	1	0.4%
3	1	0.4%
3.47	1	0.4%
4.74	1	0.4%
4.98	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
86.06	1	0.4%
84.44	1	0.4%
83.22	1	0.4%
83.1	1	0.4%
82.91	1	0.4%

percent_func_genero_masc
Numeric

Distinct count	261
Unique (%)	98.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	47.02056604
Minimum	13.94
Maximum	99.64
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	13.94
5-th percentile	23.006
Q1	32.29
Median	42.49
Q3	56.62
95-th percentile	86.726
Maximum	99.64
Range	85.7
Interquartile range	24.33

Descriptive statistics

Standard deviation	19.04481282
Coef of variation	0.4050315517
Kurtosis	0.1213098667
Mean	47.02056604
MAD	15.19650267
Skewness	0.8547835709
Sum	12460.45
Variance	362.7048955
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[13.94 26.185 52.755 69.065 99.64 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
27.07	2	0.8%
36.62	2	0.8%
30.79	2	0.8%
50	2	0.8%
52.76	1	0.4%
16.78	1	0.4%
64.01	1	0.4%
74.22	1	0.4%
36.64	1	0.4%
50.65	1	0.4%
Other values (251)	251	94.7%

Minimum 5 values

Value	Count	Frequency (%)
13.94	1	0.4%
15.56	1	0.4%
16.78	1	0.4%
16.9	1	0.4%
17.09	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
99.64	1	0.4%
97	1	0.4%
96.53	1	0.4%
95.26	1	0.4%
95.02	1	0.4%

qt_admitidos
Numeric

Distinct count	241
Unique (%)	90.9%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	915.8641509
Minimum	83
Maximum	7961
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	83
5-th percentile	177
Q1	355
Median	582
Q3	983
95-th percentile	2839.4
Maximum	7961
Range	7878
Interquartile range	628

Descriptive statistics

Standard deviation	1092.19591
Coef of variation	1.192530474
Kurtosis	16.81983238
Mean	915.8641509
MAD	641.1677892
Skewness	3.67572609
Sum	242704
Variance	1192891.906
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 83. 590.5 1045.5 1770. 3398.5 7961. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
246	2	0.8%
582	2	0.8%
1044	2	0.8%
410	2	0.8%
355	2	0.8%
1484	2	0.8%
1160	2	0.8%
1212	2	0.8%
340	2	0.8%
243	2	0.8%
Other values (231)	245	92.5%

Minimum 5 values

Value	Count	Frequency (%)
83	1	0.4%
96	1	0.4%
120	1	0.4%
130	1	0.4%
136	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
7961	1	0.4%
7803	1	0.4%
6262	1	0.4%
6103	1	0.4%
5340	1	0.4%

qt_admitidos_12meses
Numeric

Distinct count	73
Unique (%)	27.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	28.06415094
Minimum	0
Maximum	782
Zeros (%)	61.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	27
95-th percentile	132.2
Maximum	782
Range	782
Interquartile range	27

Descriptive statistics

Standard deviation	73.04087454
Coef of variation	2.602639741
Kurtosis	48.79607181
Mean	28.06415094
MAD	38.54211463
Skewness	5.908751273
Sum	7437
Variance	5334.969354
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000e+00 5.000e-01 3.850e+01 9.850e+01 2.575e+02 7.820e+02], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	162	61.1%
35	3	1.1%
8	3	1.1%
1	3	1.1%
18	3	1.1%
87	3	1.1%
13	3	1.1%
12	3	1.1%
74	2	0.8%
14	2	0.8%
Other values (63)	78	29.4%

Minimum 5 values

Value	Count	Frequency (%)
0	162	61.1%
1	3	1.1%
2	2	0.8%
4	1	0.4%
6	2	0.8%

Maximum 5 values

Value	Count	Frequency (%)
782	1	0.4%
465	1	0.4%
332	1	0.4%
259	1	0.4%
256	1	0.4%

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_art
Numeric

Distinct count	39
Unique (%)	14.7%
Missing (%)	50.9%
Missing (n)	135
Infinite (%)	0.0%
Infinite (n)	0

Mean	21.51538462
Minimum	1
Maximum	912
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2.25
Median	6
Q3	14
95-th percentile	44
Maximum	912
Range	911
Interquartile range	11.75

Descriptive statistics

Standard deviation	87.8001814
Coef of variation	4.080809289
Kurtosis	86.51934653
Mean	21.51538462
MAD	25.25633136
Skewness	8.982447187
Sum	2797
Variance	7708.871855
Memory size	14.1 KiB

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
1	20	7.5%
3	13	4.9%
2	13	4.9%
6	10	3.8%
5	9	3.4%
13	6	2.3%
7	6	2.3%
4	5	1.9%
14	4	1.5%
12	3	1.1%
Other values (28)	41	15.5%
(Missing)	135	50.9%

Minimum 5 values

Value	Count	Frequency (%)
1	20	7.5%
2	13	4.9%
3	13	4.9%
4	5	1.9%
5	9	3.4%

Maximum 5 values

Value	Count	Frequency (%)
912	1	0.4%
426	1	0.4%
88	1	0.4%
51	2	0.8%
45	1	0.4%

qt_coligadas
Numeric

Distinct count	21
Unique (%)	7.9%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	6.973684211
Minimum	1
Maximum	57
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	2
Q3	6
95-th percentile	36.5
Maximum	57
Range	56
Interquartile range	5

Descriptive statistics

Standard deviation	11.02962518
Coef of variation	1.581606629
Kurtosis	7.083269653
Mean	6.973684211
MAD	7.274930748
Skewness	2.633455034
Sum	530
Variance	121.6526316
Memory size	14.1 KiB

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	27	10.2%
2	14	5.3%
3	7	2.6%
6	7	2.6%
4	3	1.1%
15	2	0.8%
8	2	0.8%
17	2	0.8%
9	1	0.4%
36	1	0.4%
Other values (10)	10	3.8%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
1	27	10.2%
2	14	5.3%
3	7	2.6%
4	3	1.1%
5	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
57	1	0.4%
40	1	0.4%
39	1	0.4%
38	1	0.4%
36	1	0.4%

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation	1

qt_coligados_agropecuaria
Categorical

Distinct count	5
Unique (%)	1.9%
Missing (%)	71.3%
Missing (n)	189

0	70
1	3
2	2
(Missing)	189

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0	70	26.4%
1	3	1.1%
2	2	0.8%
4	1	0.4%
(Missing)	189	71.3%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

qt_coligados_atividade_alto
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_coligados_atividade_baixo
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_coligados_atividade_inativo
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_coligados_atividade_medio
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_coligados_atividade_mt_baixo
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_coligados_ativo
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation	0.9997516702

qt_coligados_baixada
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation	0.9718460044

qt_coligados_ccivil
Categorical

Distinct count	5
Unique (%)	1.9%
Missing (%)	71.3%
Missing (n)	189

0	68
1	5
2	2
(Missing)	189

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0	68	25.7%
1	5	1.9%
2	2	0.8%
3	1	0.4%
(Missing)	189	71.3%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

qt_coligados_centro
Numeric

Distinct count	6
Unique (%)	2.3%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.3157894737
Minimum	0
Maximum	8
Zeros (%)	25.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	8
Range	8
Interquartile range	0

Descriptive statistics

Standard deviation	1.298311995
Coef of variation	4.111321316
Kurtosis	25.69387946
Mean	0.3157894737
MAD	0.5650969529
Skewness	5.017307957
Sum	24
Variance	1.685614035
Memory size	14.1 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	68	25.7%
1	5	1.9%
8	1	0.4%
4	1	0.4%
7	1	0.4%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
0	68	25.7%
1	5	1.9%
4	1	0.4%
7	1	0.4%
8	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
8	1	0.4%
7	1	0.4%
4	1	0.4%
1	5	1.9%
0	68	25.7%

qt_coligados_comercio
Numeric

Distinct count	9
Unique (%)	3.4%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.092105263
Minimum	0
Maximum	26
Zeros (%)	17.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	1
95-th percentile	4
Maximum	26
Range	26
Interquartile range	1

Descriptive statistics

Standard deviation	3.154584522
Coef of variation	2.888535225
Kurtosis	53.16937363
Mean	1.092105263
MAD	1.355955679
Skewness	6.822610724
Sum	83
Variance	9.951403509
Memory size	14.1 KiB

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	46	17.4%
1	14	5.3%
2	9	3.4%
4	2	0.8%
3	2	0.8%
6	1	0.4%
5	1	0.4%
26	1	0.4%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
0	46	17.4%
1	14	5.3%
2	9	3.4%
3	2	0.8%
4	2	0.8%

Maximum 5 values

Value	Count	Frequency (%)
26	1	0.4%
6	1	0.4%
5	1	0.4%
4	2	0.8%
3	2	0.8%

qt_coligados_epp
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_coligados_exterior
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_coligados_inapta
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation	0.9718460044

qt_coligados_industria
Numeric

Distinct count	8
Unique (%)	3.0%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.4473684211
Minimum	0
Maximum	10
Zeros (%)	23.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	2.25
Maximum	10
Range	10
Interquartile range	0

Descriptive statistics

Standard deviation	1.491261094
Coef of variation	3.33340715
Kurtosis	25.37777825
Mean	0.4473684211
MAD	0.7416897507
Skewness	4.762327507
Sum	34
Variance	2.223859649
Memory size	14.1 KiB

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	63	23.8%
1	8	3.0%
10	1	0.4%
3	1	0.4%
2	1	0.4%
5	1	0.4%
6	1	0.4%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
0	63	23.8%
1	8	3.0%
2	1	0.4%
3	1	0.4%
5	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
10	1	0.4%
6	1	0.4%
5	1	0.4%
3	1	0.4%
2	1	0.4%

qt_coligados_ltda
Numeric

Distinct count	6
Unique (%)	2.3%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.2631578947
Minimum	0
Maximum	8
Zeros (%)	26.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	8
Range	8
Interquartile range	0

Descriptive statistics

Standard deviation	1.170395045
Coef of variation	4.447501171
Kurtosis	32.87682671
Mean	0.2631578947
MAD	0.4778393352
Skewness	5.61595368
Sum	20
Variance	1.369824561
Memory size	14.1 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	69	26.0%
1	4	1.5%
2	1	0.4%
8	1	0.4%
6	1	0.4%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
0	69	26.0%
1	4	1.5%
2	1	0.4%
6	1	0.4%
8	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
8	1	0.4%
6	1	0.4%
2	1	0.4%
1	4	1.5%
0	69	26.0%

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation	0.9996971343

qt_coligados_me
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_coligados_mei
Boolean

Distinct count	3
Unique (%)	1.1%
Missing (%)	71.3%
Missing (n)	189

0	75
1	1
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	75	28.3%
1	1	0.4%
(Missing)	189	71.3%

qt_coligados_nordeste
Numeric

Distinct count	14
Unique (%)	5.3%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.618421053
Minimum	0
Maximum	36
Zeros (%)	11.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	1
Q3	2.25
95-th percentile	9.75
Maximum	36
Range	36
Interquartile range	2.25

Descriptive statistics

Standard deviation	5.53767004
Coef of variation	2.114889061
Kurtosis	20.6502858
Mean	2.618421053
MAD	3.006578947
Skewness	4.20720687
Sum	199
Variance	30.66578947
Memory size	14.1 KiB

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	31	11.7%
1	17	6.4%
2	9	3.4%
6	4	1.5%
3	4	1.5%
4	4	1.5%
36	1	0.4%
25	1	0.4%
12	1	0.4%
5	1	0.4%
Other values (3)	3	1.1%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
0	31	11.7%
1	17	6.4%
2	9	3.4%
3	4	1.5%
4	4	1.5%

Maximum 5 values

Value	Count	Frequency (%)
36	1	0.4%
25	1	0.4%
17	1	0.4%
12	1	0.4%
9	1	0.4%

qt_coligados_norte
Numeric

Distinct count	14
Unique (%)	5.3%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.881578947
Minimum	0
Maximum	52
Zeros (%)	14.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	2
95-th percentile	11.75
Maximum	52
Range	52
Interquartile range	2

Descriptive statistics

Standard deviation	7.575340882
Coef of variation	2.62888542
Kurtosis	26.25778584
Mean	2.881578947
MAD	3.789819945
Skewness	4.775758542
Sum	219
Variance	57.38578947
Memory size	14.1 KiB

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	39	14.7%
1	14	5.3%
2	6	2.3%
5	3	1.1%
3	3	1.1%
4	2	0.8%
9	2	0.8%
6	2	0.8%
22	1	0.4%
11	1	0.4%
Other values (3)	3	1.1%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
0	39	14.7%
1	14	5.3%
2	6	2.3%
3	3	1.1%
4	2	0.8%

Maximum 5 values

Value	Count	Frequency (%)
52	1	0.4%
32	1	0.4%
22	1	0.4%
14	1	0.4%
11	1	0.4%

qt_coligados_nula
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_coligados_sa
Numeric

Distinct count	7
Unique (%)	2.6%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.5394736842
Minimum	0
Maximum	10
Zeros (%)	24.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	4
Maximum	10
Range	10
Interquartile range	0

Descriptive statistics

Standard deviation	1.700515918
Coef of variation	3.152175847
Kurtosis	16.01041505
Mean	0.5394736842
MAD	0.9085872576
Skewness	3.882045201
Sum	41
Variance	2.891754386
Memory size	14.1 KiB

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	64	24.2%
1	6	2.3%
4	3	1.1%
10	1	0.4%
7	1	0.4%
6	1	0.4%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
0	64	24.2%
1	6	2.3%
4	3	1.1%
6	1	0.4%
7	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
10	1	0.4%
7	1	0.4%
6	1	0.4%
4	3	1.1%
1	6	2.3%

qt_coligados_serviço
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation	0.9288399907

qt_coligados_sudeste
Numeric

Distinct count	9
Unique (%)	3.4%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.013157895
Minimum	0
Maximum	28
Zeros (%)	24.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	3.75
Maximum	28
Range	28
Interquartile range	0

Descriptive statistics

Standard deviation	4.067737851
Coef of variation	4.014910087
Kurtosis	31.87862308
Mean	1.013157895
MAD	1.733379501
Skewness	5.47611395
Sum	77
Variance	16.54649123
Memory size	14.1 KiB

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	65	24.5%
2	4	1.5%
3	2	0.8%
1	1	0.4%
8	1	0.4%
6	1	0.4%
28	1	0.4%
20	1	0.4%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
0	65	24.5%
1	1	0.4%
2	4	1.5%
3	2	0.8%
6	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
28	1	0.4%
20	1	0.4%
8	1	0.4%
6	1	0.4%
3	2	0.8%

qt_coligados_sul
Highly correlated

This variable is highly correlated with qt_coligados_baixada and should be ignored for analysis

Correlation	0.9612903226

qt_coligados_suspensa
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	71.3%
Missing (n)	189

0	76
(Missing)	189

Toggle details

Value	Count	Frequency (%)
0	76	28.7%
(Missing)	189	71.3%

qt_desligados
Highly correlated

This variable is highly correlated with qt_admitidos and should be ignored for analysis

Correlation	0.905610227

qt_desligados_12meses
Numeric

Distinct count	73
Unique (%)	27.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	23.92075472
Minimum	0
Maximum	394
Zeros (%)	60.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	21
95-th percentile	125.6
Maximum	394
Range	394
Interquartile range	21

Descriptive statistics

Standard deviation	59.92998869
Coef of variation	2.505355262
Kurtosis	18.14991854
Mean	23.92075472
MAD	32.95723745
Skewness	4.020251455
Sum	6339
Variance	3591.603545
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 29.5 71. 394. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	159	60.0%
27	6	2.3%
9	5	1.9%
8	4	1.5%
22	4	1.5%
29	3	1.1%
7	3	1.1%
1	3	1.1%
11	3	1.1%
5	3	1.1%
Other values (63)	72	27.2%

Minimum 5 values

Value	Count	Frequency (%)
0	159	60.0%
1	3	1.1%
2	1	0.4%
3	2	0.8%
4	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
394	1	0.4%
379	1	0.4%
366	1	0.4%
345	1	0.4%
277	1	0.4%

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation	0.9999991015

qt_filiais
Numeric

Distinct count	21
Unique (%)	7.9%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.554716981
Minimum	0
Maximum	172
Zeros (%)	58.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	1
95-th percentile	9.8
Maximum	172
Range	172
Interquartile range	1

Descriptive statistics

Standard deviation	12.01001107
Coef of variation	4.701112162
Kurtosis	153.0330249
Mean	2.554716981
MAD	3.681594874
Skewness	11.40867694
Sum	677
Variance	144.2403659
Memory size	14.1 KiB

Histogram with fixed size bins (bins=21)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 3.5 16.5 172. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	155	58.5%
1	53	20.0%
2	17	6.4%
3	10	3.8%
5	4	1.5%
7	3	1.1%
4	3	1.1%
10	3	1.1%
12	2	0.8%
9	2	0.8%
Other values (11)	13	4.9%

Minimum 5 values

Value	Count	Frequency (%)
0	155	58.5%
1	53	20.0%
2	17	6.4%
3	10	3.8%
4	3	1.1%

Maximum 5 values

Value	Count	Frequency (%)
172	1	0.4%
51	1	0.4%
49	1	0.4%
42	1	0.4%
33	1	0.4%

qt_funcionarios
Numeric

Distinct count	231
Unique (%)	87.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	468.6
Minimum	68
Maximum	3919
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	68
5-th percentile	116
Q1	188
Median	313
Q3	539
95-th percentile	1321.2
Maximum	3919
Range	3851
Interquartile range	351

Descriptive statistics

Standard deviation	494.5689568
Coef of variation	1.055418175
Kurtosis	16.01577453
Mean	468.6
MAD	310.0649057
Skewness	3.441655417
Sum	124179
Variance	244598.453
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 68. 117.5 233.5 549.5 902.5 1927.5 3919. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
349	2	0.8%
353	2	0.8%
378	2	0.8%
677	2	0.8%
219	2	0.8%
188	2	0.8%
186	2	0.8%
199	2	0.8%
317	2	0.8%
212	2	0.8%
Other values (221)	245	92.5%

Minimum 5 values

Value	Count	Frequency (%)
68	1	0.4%
76	1	0.4%
82	1	0.4%
83	1	0.4%
85	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
3919	1	0.4%
3172	1	0.4%
3104	1	0.4%
2669	1	0.4%
1936	1	0.4%

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation	0.9948729203

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation	0.968894117

qt_funcionarios_coligados
Numeric

Distinct count	53
Unique (%)	20.0%
Missing (%)	76.2%
Missing (n)	202
Infinite (%)	0.0%
Infinite (n)	0

Mean	551.031746
Minimum	0
Maximum	4770
Zeros (%)	1.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10.5
Median	112
Q3	510.5
95-th percentile	3090.1
Maximum	4770
Range	4770
Interquartile range	500

Descriptive statistics

Standard deviation	1079.387595
Coef of variation	1.958848292
Kurtosis	7.119124121
Mean	551.031746
MAD	685.382716
Skewness	2.731363438
Sum	34715
Variance	1165077.58
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5	1.9%
4	3	1.1%
23	2	0.8%
3	2	0.8%
1	2	0.8%
11	2	0.8%
617	2	0.8%
54	1	0.4%
152	1	0.4%
312	1	0.4%
Other values (42)	42	15.8%
(Missing)	202	76.2%

Minimum 5 values

Value	Count	Frequency (%)
0	5	1.9%
1	2	0.8%
2	1	0.4%
3	2	0.8%
4	3	1.1%

Maximum 5 values

Value	Count	Frequency (%)
4770	1	0.4%
4463	1	0.4%
4124	1	0.4%
3183	1	0.4%
2254	1	0.4%

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with qt_coligados_inapta and should be ignored for analysis

Correlation	0.9231363224

qt_funcionarios_grupo
Highly correlated

This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis

Correlation	0.9502971077

qt_ramos_coligados
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation	0.9346159264

qt_regioes_coligados
Numeric

Distinct count	6
Unique (%)	2.3%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.407894737
Minimum	1
Maximum	5
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	1
95-th percentile	4
Maximum	5
Range	4
Interquartile range	0

Descriptive statistics

Standard deviation	0.9118133081
Coef of variation	0.6476430973
Kurtosis	4.718362297
Mean	1.407894737
MAD	0.6440443213
Skewness	2.339935018
Sum	107
Variance	0.8314035088
Memory size	14.1 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	60	22.6%
2	7	2.6%
3	4	1.5%
4	4	1.5%
5	1	0.4%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
1	60	22.6%
2	7	2.6%
3	4	1.5%
4	4	1.5%
5	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
5	1	0.4%
4	4	1.5%
3	4	1.5%
2	7	2.6%
1	60	22.6%

qt_socios
Highly correlated

This variable is highly correlated with qt_coligados_mei and should be ignored for analysis

Correlation	0.9899466719

qt_socios_coligados
Numeric

Distinct count	23
Unique (%)	8.7%
Missing (%)	71.3%
Missing (n)	189
Infinite (%)	0.0%
Infinite (n)	0

Mean	12.76315789
Minimum	1
Maximum	138
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	3
Q3	12
95-th percentile	58.5
Maximum	138
Range	137
Interquartile range	11

Descriptive statistics

Standard deviation	26.83125959
Coef of variation	2.102243019
Kurtosis	12.26288439
Mean	12.76315789
MAD	15.08587258
Skewness	3.488701101
Sum	970
Variance	719.9164912
Memory size	14.1 KiB

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
1	24	9.1%
2	13	4.9%
4	5	1.9%
3	4	1.5%
5	4	1.5%
14	3	1.1%
6	3	1.1%
24	2	0.8%
28	2	0.8%
12	2	0.8%
Other values (12)	14	5.3%
(Missing)	189	71.3%

Minimum 5 values

Value	Count	Frequency (%)
1	24	9.1%
2	13	4.9%
3	4	1.5%
4	5	1.9%
5	4	1.5%

Maximum 5 values

Value	Count	Frequency (%)
138	1	0.4%
128	1	0.4%
107	1	0.4%
96	1	0.4%
46	1	0.4%

qt_socios_feminino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation	0.9936468189

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios_feminino and should be ignored for analysis

Correlation	0.9916264524

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation	0.9954550751

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation	0.9960939342

qt_socios_pj
Numeric

Distinct count	6
Unique (%)	2.3%
Missing (%)	63.0%
Missing (n)	167
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.2551020408
Minimum	0
Maximum	5
Zeros (%)	31.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	2
Maximum	5
Range	5
Interquartile range	0

Descriptive statistics

Standard deviation	0.7365456361
Coef of variation	2.887258893
Kurtosis	19.40726857
Mean	0.2551020408
MAD	0.4321116202
Skewness	3.979704856
Sum	25
Variance	0.542499474
Memory size	14.1 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	83	31.3%
1	9	3.4%
2	4	1.5%
5	1	0.4%
3	1	0.4%
(Missing)	167	63.0%

Minimum 5 values

Value	Count	Frequency (%)
0	83	31.3%
1	9	3.4%
2	4	1.5%
3	1	0.4%
5	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
5	1	0.4%
3	1	0.4%
2	4	1.5%
1	9	3.4%
0	83	31.3%

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation	1

qt_socios_pj_baixados
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	94.3%
Missing (n)	250

0	15
(Missing)	250

Toggle details

Value	Count	Frequency (%)
0	15	5.7%
(Missing)	250	94.3%

qt_socios_pj_inaptos
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	94.3%
Missing (n)	250

0	15
(Missing)	250

Toggle details

Value	Count	Frequency (%)
0	15	5.7%
(Missing)	250	94.3%

qt_socios_pj_nulos
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	94.3%
Missing (n)	250

0	15
(Missing)	250

Toggle details

Value	Count	Frequency (%)
0	15	5.7%
(Missing)	250	94.3%

qt_socios_pj_suspensos
Boolean

Distinct count	2
Unique (%)	0.8%
Missing (%)	94.3%
Missing (n)	250

0	15
(Missing)	250

Toggle details

Value	Count	Frequency (%)
0	15	5.7%
(Missing)	250	94.3%

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation	0.9983592345

qt_socios_st_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_ufs_coligados
Highly correlated

This variable is highly correlated with qt_regioes_coligados and should be ignored for analysis

Correlation	0.9026409791

setor
Constant

This variable is constant and should be ignored for analysis

Constant value	SERVIÇO

sg_uf
Categorical

Distinct count	6
Unique (%)	2.3%
Missing (%)	0.0%
Missing (n)	0

MA	74
PI	52
RN	51
Other values (3)	88

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MA	74	27.9%
PI	52	19.6%
RN	51	19.2%
AM	43	16.2%
AC	23	8.7%
RO	22	8.3%

Max length	2
Mean length	2
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

sg_uf_matriz
Recoded

This variable is a recoding of sg_uf and should be ignored for analysis

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation	0.9016602831

total
Highly correlated

This variable is highly correlated with qt_funcionarios_grupo and should be ignored for analysis

Correlation	0.9743124436

total_filiais_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis

Correlation	0.9354643228

tx_crescimento_12meses
Numeric

Distinct count	104
Unique (%)	39.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	51.83115614
Minimum	-29.63265306
Maximum	12700
Zeros (%)	60.8%

Toggle details

Quantile statistics

Minimum	-29.63265306
5-th percentile	-6.509605013
Q1	0
Median	0
Q3	0
95-th percentile	29.53423981
Maximum	12700
Range	12729.63265
Interquartile range	0

Descriptive statistics

Standard deviation	780.1739957
Coef of variation	15.05222059
Kurtosis	264.6427775
Mean	51.83115614
MAD	97.85147727
Skewness	16.26255534
Sum	13735.25638
Variance	608671.4636
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[-2.96326531e+01 -1.45611587e+01 -3.66344006e+00 -7.15307582e-02 1.46627566e-01 6.80991490e+00 2.07987427e+01 8.88235294e+01 1.27000000e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	161	60.8%
6.382978723	2	0.8%
40.6779661	1	0.4%
13.71115174	1	0.4%
75.6097561	1	0.4%
27.1393643	1	0.4%
40.99099099	1	0.4%
-9.80861244	1	0.4%
-1.45631068	1	0.4%
-29.63265306	1	0.4%
Other values (94)	94	35.5%

Minimum 5 values

Value	Count	Frequency (%)
-29.63265306	1	0.4%
-25.87917042	1	0.4%
-14.604811	1	0.4%
-14.5175064	1	0.4%
-13.58024691	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
12700	1	0.4%
246.1538462	1	0.4%
100	1	0.4%
77.64705882	1	0.4%
75.6097561	1	0.4%

tx_crescimento_24meses
Highly correlated

This variable is highly correlated with tx_crescimento_12meses and should be ignored for analysis

Correlation	0.9959598268

tx_rotatividade
Numeric

Distinct count	106
Unique (%)	40.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	6.566274968
Minimum	0
Maximum	101.0869565
Zeros (%)	60.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	11.39369278
95-th percentile	28.69354055
Maximum	101.0869565
Range	101.0869565
Interquartile range	11.39369278

Descriptive statistics

Standard deviation	11.82783766
Coef of variation	1.801300999
Kurtosis	16.07742863
Mean	6.566274968
MAD	8.611309487
Skewness	3.063189929
Sum	1740.062866
Variance	139.8977438
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 6.69344043e-02 2.31021759e+01 4.14632035e+01 1.01086957e+02], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	160	60.4%
9.03696942	1	0.4%
36.06557377	1	0.4%
40.25974026	1	0.4%
2.575107296	1	0.4%
4.532577904	1	0.4%
18.73605948	1	0.4%
34.30232558	1	0.4%
4.888888889	1	0.4%
9.900990099	1	0.4%
Other values (96)	96	36.2%

Minimum 5 values

Value	Count	Frequency (%)
0	160	60.4%
0.1338688086	1	0.4%
0.1431639227	1	0.4%
0.5611672278	1	0.4%
0.8298755187	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
101.0869565	1	0.4%
55.35248042	1	0.4%
42.66666667	1	0.4%
40.25974026	1	0.4%
39.18367347	1	0.4%

Unnamed_0_x
Numeric

Distinct count	265
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	132
Minimum	0
Maximum	264
Zeros (%)	0.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	13.2
Q1	66
Median	132
Q3	198
95-th percentile	250.8
Maximum	264
Range	264
Interquartile range	132

Descriptive statistics

Standard deviation	76.64311232
Coef of variation	0.5806296388
Kurtosis	-1.2
Mean	132
MAD	66.2490566
Skewness	0
Sum	34980
Variance	5874.166667
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 264.], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
264	1	0.4%
82	1	0.4%
96	1	0.4%
95	1	0.4%
94	1	0.4%
93	1	0.4%
92	1	0.4%
91	1	0.4%
90	1	0.4%
89	1	0.4%
Other values (255)	255	96.2%

Minimum 5 values

Value	Count	Frequency (%)
0	1	0.4%
1	1	0.4%
2	1	0.4%
3	1	0.4%
4	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
264	1	0.4%
263	1	0.4%
262	1	0.4%
261	1	0.4%
260	1	0.4%

Unnamed_0_y
Highly correlated

This variable is highly correlated with Unnamed_0_x and should be ignored for analysis

Correlation	0.9988970638

vl_faturamento_estimado_aux
Numeric

Distinct count	248
Unique (%)	93.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	108007862.2
Minimum	20039724
Maximum	2011596800
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	20039724
5-th percentile	22584614.4
Q1	30600504
Median	51000840
Q3	99786500
95-th percentile	378652900
Maximum	2011596800
Range	1991557076
Interquartile range	69185996

Descriptive statistics

Standard deviation	192627638.9
Coef of variation	1.783459417
Kurtosis	45.08106971
Mean	108007862.2
MAD	94175330.34
Skewness	5.851507067
Sum	2.862208347e+10
Variance	3.710540726e+16
Memory size	14.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[2.00397240e+07 3.85339680e+07 6.86708350e+07 1.47026665e+08 3.25967480e+08 7.09529855e+08 2.01159680e+09], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
24624648	3	1.1%
24882228	2	0.8%
49661424	2	0.8%
45282564	2	0.8%
24418584	2	0.8%
23336748	2	0.8%
117404960	2	0.8%
23388264	2	0.8%
27818640	2	0.8%
27870156	2	0.8%
Other values (238)	244	92.1%

Minimum 5 values

Value	Count	Frequency (%)
20039724	1	0.4%
20245788	1	0.4%
20606400	2	0.8%
20709432	1	0.4%
20760948	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
2011596800	1	0.4%
1375889300	1	0.4%
930378940	1	0.4%
914615040	1	0.4%
755585150	1	0.4%

vl_faturamento_estimado_grupo_aux
Highly correlated

This variable is highly correlated with vl_faturamento_estimado_aux and should be ignored for analysis

Correlation	0.9811022766

vl_folha_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation	0.961120251

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with vl_folha_coligados and should be ignored for analysis

Correlation	0.9428868609

vl_frota
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation	0.9138805515

vl_idade_maxima_socios_pj
Numeric

Distinct count	16
Unique (%)	6.0%
Missing (%)	94.3%
Missing (n)	250
Infinite (%)	0.0%
Infinite (n)	0

Mean	24.03741729
Minimum	0.7611225188
Maximum	52.28199863
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.7611225188
5-th percentile	3.229568789
Q1	9.338809035
Median	27.80013689
Q3	35.41820671
95-th percentile	47.39685147
Maximum	52.28199863
Range	51.52087611
Interquartile range	26.07939767

Descriptive statistics

Standard deviation	16.28980879
Coef of variation	0.6776854846
Kurtosis	-1.234614151
Mean	24.03741729
MAD	14.08228763
Skewness	0.1416487434
Sum	360.5612594
Variance	265.3578703
Memory size	14.1 KiB

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
27.80013689	1	0.4%
32.94182067	1	0.4%
7.882272416	1	0.4%
18.33812457	1	0.4%
52.28199863	1	0.4%
4.287474333	1	0.4%
10.79534565	1	0.4%
37.89459274	1	0.4%
14.28336756	1	0.4%
40.98288843	1	0.4%
Other values (5)	5	1.9%
(Missing)	250	94.3%

Minimum 5 values

Value	Count	Frequency (%)
0.7611225188	1	0.4%
4.287474333	1	0.4%
6.29705681	1	0.4%
7.882272416	1	0.4%
10.79534565	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
52.28199863	1	0.4%
45.30321697	1	0.4%
40.98288843	1	0.4%
37.89459274	1	0.4%
32.94182067	1	0.4%

vl_idade_media_socios_pj
Numeric

Distinct count	16
Unique (%)	6.0%
Missing (%)	94.3%
Missing (n)	250
Infinite (%)	0.0%
Infinite (n)	0

Mean	17.75692144
Minimum	0.7611225188
Maximum	40.98288843
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.7611225188
5-th percentile	3.229568789
Q1	9.338809035
Median	15.05087839
Q3	27.46817248
95-th percentile	35.354141
Maximum	40.98288843
Range	40.22176591
Interquartile range	18.12936345

Descriptive statistics

Standard deviation	11.97944205
Coef of variation	0.6746350763
Kurtosis	-0.7206734384
Mean	17.75692144
MAD	9.726381626
Skewness	0.5442538678
Sum	266.3538216
Variance	143.5070318
Memory size	14.1 KiB

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
32.94182067	1	0.4%
7.882272416	1	0.4%
18.33812457	1	0.4%
15.05087839	1	0.4%
32.29021218	1	0.4%
4.287474333	1	0.4%
15.93839836	1	0.4%
10.79534565	1	0.4%
14.28336756	1	0.4%
23.5742642	1	0.4%
Other values (5)	5	1.9%
(Missing)	250	94.3%

Minimum 5 values

Value	Count	Frequency (%)
0.7611225188	1	0.4%
4.287474333	1	0.4%
6.29705681	1	0.4%
7.882272416	1	0.4%
10.79534565	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
40.98288843	1	0.4%
32.94182067	1	0.4%
32.29021218	1	0.4%
31.36208077	1	0.4%
23.5742642	1	0.4%

vl_idade_minima_socios_pj
Numeric

Distinct count	16
Unique (%)	6.0%
Missing (%)	94.3%
Missing (n)	250
Infinite (%)	0.0%
Infinite (n)	0

Mean	13.75952544
Minimum	0.6598220397
Maximum	40.98288843
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.6598220397
5-th percentile	0.7307323751
Q1	3.957563313
Median	10.79534565
Q3	18.84325804
95-th percentile	35.354141
Maximum	40.98288843
Range	40.32306639
Interquartile range	14.88569473

Descriptive statistics

Standard deviation	12.62551595
Coef of variation	0.9175836775
Kurtosis	0.03197410952
Mean	13.75952544
MAD	9.959936117
Skewness	1.005764265
Sum	206.3928816
Variance	159.4036531
Memory size	14.1 KiB

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
32.94182067	1	0.4%
7.882272416	1	0.4%
12.29842574	1	0.4%
18.33812457	1	0.4%
4.287474333	1	0.4%
0.6598220397	1	0.4%
10.79534565	1	0.4%
14.28336756	1	0.4%
40.98288843	1	0.4%
31.36208077	1	0.4%
Other values (5)	5	1.9%
(Missing)	250	94.3%

Minimum 5 values

Value	Count	Frequency (%)
0.6598220397	1	0.4%
0.7611225188	1	0.4%
2.527036277	1	0.4%
3.627652293	1	0.4%
4.287474333	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
40.98288843	1	0.4%
32.94182067	1	0.4%
31.36208077	1	0.4%
19.34839151	1	0.4%
18.33812457	1	0.4%

vl_potenc_cons_oleo_gas
Numeric

Distinct count	21
Unique (%)	7.9%
Missing (%)	91.7%
Missing (n)	243
Infinite (%)	0.0%
Infinite (n)	0

Mean	101.9090909
Minimum	1
Maximum	430
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	2.05
Q1	21.25
Median	45
Q3	163.5
95-th percentile	368.45
Maximum	430
Range	429
Interquartile range	142.25

Descriptive statistics

Standard deviation	125.4428001
Coef of variation	1.230928458
Kurtosis	1.339303396
Mean	101.9090909
MAD	100.5123967
Skewness	1.485816228
Sum	2242
Variance	15735.8961
Memory size	14.1 KiB

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
32	2	0.8%
45	2	0.8%
22	1	0.4%
7	1	0.4%
216	1	0.4%
374	1	0.4%
226	1	0.4%
3	1	0.4%
138	1	0.4%
172	1	0.4%
Other values (10)	10	3.8%
(Missing)	243	91.7%

Minimum 5 values

Value	Count	Frequency (%)
1	1	0.4%
2	1	0.4%
3	1	0.4%
7	1	0.4%
8	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
430	1	0.4%
374	1	0.4%
263	1	0.4%
226	1	0.4%
216	1	0.4%

vl_total_tancagem
Categorical

Distinct count	5
Unique (%)	1.9%
Missing (%)	96.2%
Missing (n)	255

15	7
45	1
40	1
(Missing)	255

Toggle details

Common values
Composition

Value	Count	Frequency (%)
15	7	2.6%
45	1	0.4%
40	1	0.4%
30	1	0.4%
(Missing)	255	96.2%

Max length	4
Mean length	3.037735849
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

vl_total_tancagem_grupo
Highly correlated

This variable is highly correlated with vl_idade_minima_socios_pj and should be ignored for analysis

Correlation	0.9444166274

vl_total_veiculos_antt
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

vl_total_veiculos_antt_grupo
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

vl_total_veiculos_leves
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation	0.9328182339

vl_total_veiculos_leves_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_leves and should be ignored for analysis

Correlation	0.9972729314

vl_total_veiculos_pesados
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation	0.9929030146

vl_total_veiculos_pesados_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_pesados and should be ignored for analysis

Correlation	0.9978083954

First rows

	coligada_mais_antiga_ativa	coligada_mais_antiga_baixada	coligada_mais_nova_ativa	coligada_mais_nova_baixada	de_faixa_faturamento_estimado	de_faixa_faturamento_estimado_grupo	de_indicador_telefone	de_natureza_juridica	de_nivel_atividade	de_ramo	de_saude_rescencia	de_saude_tributaria	dt_situacao	empsetorcensitariofaixarendapopulacao	faturamento_est_coligados	faturamento_est_coligados_gp	fl_antt	fl_email	fl_epp	fl_ltda	fl_matriz	fl_me	fl_mei	fl_optante_simei	fl_optante_simples	fl_passivel_iss	fl_rm	fl_sa	fl_simples_irregular	fl_spa	fl_st_especial	fl_telefone	fl_veiculo	grau_instrucao_macro_analfabeto	grau_instrucao_macro_desconhecido	grau_instrucao_macro_escolaridade_fundamental	grau_instrucao_macro_escolaridade_media	grau_instrucao_macro_escolaridade_superior	id	idade_acima_de_58	idade_ate_18	idade_de_19_a_23	idade_de_24_a_28	idade_de_29_a_33	idade_de_34_a_38	idade_de_39_a_43	idade_de_44_a_48	idade_de_49_a_53	idade_de_54_a_58	idade_emp_cat	idade_empresa_anos	idade_maxima_coligadas	idade_maxima_socios	idade_media_coligadas	idade_media_coligadas_ativas	idade_media_coligadas_baixadas	idade_media_socios	idade_minima_coligadas	idade_minima_socios	max_faturamento_est_coligados	max_faturamento_est_coligados_gp	max_filiais_coligados	max_funcionarios_coligados_gp	max_meses_servicos	max_meses_servicos_all	max_vl_folha_coligados	max_vl_folha_coligados_gp	media_faturamento_est_coligados	media_faturamento_est_coligados_gp	media_filiais_coligados	media_funcionarios_coligados_gp	media_meses_servicos	media_meses_servicos_all	media_vl_folha_coligados	media_vl_folha_coligados_gp	meses_ultima_contratacaco	min_faturamento_est_coligados	min_faturamento_est_coligados_gp	min_filiais_coligados	min_funcionarios_coligados_gp	min_meses_servicos	min_meses_servicos_all	min_vl_folha_coligados	min_vl_folha_coligados_gp	natureza_juridica_macro	nm_divisao	nm_meso_regiao	nm_micro_regiao	nm_segmento	nu_meses_rescencia	percent_func_genero_fem	percent_func_genero_masc	qt_admitidos	qt_admitidos_12meses	qt_alteracao_socio_180d	qt_alteracao_socio_365d	qt_alteracao_socio_90d	qt_alteracao_socio_total	qt_art	qt_coligadas	qt_coligados	qt_coligados_agropecuaria	qt_coligados_atividade_alto	qt_coligados_atividade_baixo	qt_coligados_atividade_inativo	qt_coligados_atividade_medio	qt_coligados_atividade_mt_baixo	qt_coligados_ativo	qt_coligados_baixada	qt_coligados_ccivil	qt_coligados_centro	qt_coligados_comercio	qt_coligados_epp	qt_coligados_exterior	qt_coligados_inapta	qt_coligados_industria	qt_coligados_ltda	qt_coligados_matriz	qt_coligados_me	qt_coligados_mei	qt_coligados_nordeste	qt_coligados_norte	qt_coligados_nula	qt_coligados_sa	qt_coligados_serviço	qt_coligados_sudeste	qt_coligados_sul	qt_coligados_suspensa	qt_desligados	qt_desligados_12meses	qt_ex_funcionarios	qt_filiais	qt_funcionarios	qt_funcionarios_12meses	qt_funcionarios_24meses	qt_funcionarios_coligados	qt_funcionarios_coligados_gp	qt_funcionarios_grupo	qt_ramos_coligados	qt_regioes_coligados	qt_socios	qt_socios_coligados	qt_socios_feminino	qt_socios_masculino	qt_socios_pep	qt_socios_pf	qt_socios_pj	qt_socios_pj_ativos	qt_socios_pj_baixados	qt_socios_pj_inaptos	qt_socios_pj_nulos	qt_socios_pj_suspensos	qt_socios_st_regular	qt_socios_st_suspensa	qt_ufs_coligados	setor	sg_uf	sg_uf_matriz	sum_faturamento_estimado_coligadas	total	total_filiais_coligados	tx_crescimento_12meses	tx_crescimento_24meses	tx_rotatividade	Unnamed_0_x	Unnamed_0_y	vl_faturamento_estimado_aux	vl_faturamento_estimado_grupo_aux	vl_folha_coligados	vl_folha_coligados_gp	vl_frota	vl_idade_maxima_socios_pj	vl_idade_media_socios_pj	vl_idade_minima_socios_pj	vl_potenc_cons_oleo_gas	vl_total_tancagem	vl_total_tancagem_grupo	vl_total_veiculos_antt	vl_total_veiculos_antt_grupo	vl_total_veiculos_leves	vl_total_veiculos_leves_grupo	vl_total_veiculos_pesados	vl_total_veiculos_pesados_grupo
0	NaN	NaN	NaN	NaN	DE R$ 100.000.000,01 A R$ 300.000.000,00	DE R$ 100.000.000,01 A R$ 300.000.000,00	NaN	MUNICIPIO	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	VERDE	2005-11-03	644.27	NaN	NaN	False	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	False	True	NaN	NaN	117.0	106.0	522.0	bb61c09449a1c1f8b78955d8b7a7f73599e78358993fe2...	45.0	NaN	NaN	44.0	107.0	162.0	161.0	113.0	69.0	44.0	> 20	21.813699	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	259.166667	259.166667	NaN	NaN	NaN	NaN	NaN	NaN	144.663535	133.286943	NaN	NaN	40.500000	NaN	NaN	NaN	NaN	40.500000	-2.466667	NaN	NaN	OUTROS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	OESTE MARANHENSE	PINDARE	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	26.0	63.36	36.64	845.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	100.0	0.0	100.0	2	745.0	745.0	745.0	NaN	NaN	745.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	MA	MA	NaN	745.0	NaN	0.000000	0.000000	0.000000	0	3116	141308380.0	144348380.0	NaN	NaN	275282.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5.0	5.0	2.0	2.0
1	NaN	NaN	NaN	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE SIMPLES LIMITADA	ALTA	SERVICOS DE EDUCACAO	ACIMA DE 1 ANO	VERDE	2005-09-24	688.31	NaN	NaN	False	False	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	True	NaN	NaN	19.0	9.0	91.0	16843c9ffb920170477118933798510d8d5f00f5c56c12...	2.0	NaN	1.0	10.0	27.0	30.0	20.0	15.0	11.0	3.0	15 a 20	16.389041	NaN	70.0	NaN	NaN	NaN	70.0	NaN	70.0	NaN	NaN	NaN	NaN	149.033333	149.033333	NaN	NaN	NaN	NaN	NaN	NaN	65.942017	42.166782	NaN	NaN	4.866667	NaN	NaN	NaN	NaN	4.866667	0.000000	NaN	NaN	ENTIDADES EMPRESARIAIS	EDUCACAO	NORTE PIAUIENSE	BAIXO PARNAIBA PIAUIENSE	EDUCACAO	23.0	47.90	52.10	291.0	21.0	NaN	NaN	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	172.0	7.0	172.0	0	119.0	104.0	113.0	NaN	NaN	119.0	NaN	NaN	2.0	NaN	1.0	NaN	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	1.0	NaN	NaN	SERVIÇO	PI	PI	NaN	119.0	NaN	14.423077	5.309735	6.250000	1	3681	27818640.0	27818640.0	NaN	NaN	60101.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	1.0	1.0	1.0
2	NaN	NaN	NaN	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU D...	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	AZUL	1998-07-28	1881.35	NaN	NaN	False	True	False	False	True	False	False	False	False	True	SIM	False	False	False	False	True	False	NaN	NaN	56.0	26.0	88.0	1b8d092daff12bed8b3c2ab93bf5df2921865a68aca185...	73.0	NaN	1.0	7.0	10.0	11.0	12.0	9.0	14.0	33.0	> 20	40.380822	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	557.866667	5014.966667	NaN	NaN	NaN	NaN	NaN	NaN	284.854706	216.077090	NaN	NaN	24.200000	NaN	NaN	NaN	NaN	24.200000	0.633333	NaN	NaN	ADMINISTRACAO PUBLICA	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	CENTRO AMAZONENSE	MANAUS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	56.47	43.53	291.0	0.0	NaN	NaN	NaN	NaN	32.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	121.0	0.0	121.0	0	170.0	170.0	177.0	NaN	NaN	170.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	AM	AM	NaN	170.0	NaN	0.000000	-3.954802	0.000000	2	4784	92728800.0	92728800.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0
3	NaN	NaN	NaN	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	MUNICIPIO	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	AZUL	2005-10-14	353.66	NaN	NaN	False	False	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	True	NaN	NaN	35.0	53.0	63.0	3aafa3a1f12f483740a52956af100223333d0e3c79bf2c...	14.0	NaN	NaN	NaN	8.0	18.0	29.0	22.0	31.0	29.0	> 20	43.854795	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	506.966667	5014.966667	NaN	NaN	NaN	NaN	NaN	NaN	189.020309	316.503220	NaN	NaN	31.333333	NaN	NaN	NaN	NaN	31.333333	8.733333	NaN	NaN	OUTROS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	CENTRO NORTE PIAUIENSE	VALENCA DO PIAUI	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	73.51	26.49	176.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25.0	0.0	25.0	0	151.0	151.0	151.0	NaN	NaN	151.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	PI	PI	NaN	151.0	NaN	0.000000	0.000000	0.000000	3	7429	24418584.0	24418584.0	NaN	NaN	87223.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	1.0	2.0	2.0
4	NaN	NaN	NaN	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	NaN	MUNICIPIO	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	AZUL	2005-06-11	NaN	NaN	NaN	False	False	False	False	True	False	False	False	False	True	NAO	False	False	False	False	False	True	NaN	NaN	NaN	147.0	82.0	c60431fbca90067f105570e1e8a684bcd7048205bbf6c4...	24.0	NaN	NaN	6.0	10.0	12.0	45.0	50.0	48.0	34.0	> 20	43.865753	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	556.833333	5014.966667	NaN	NaN	NaN	NaN	NaN	NaN	238.418341	146.443381	NaN	NaN	23.200000	NaN	NaN	NaN	NaN	34.033333	-0.066667	NaN	NaN	OUTROS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	AGRESTE POTIGUAR	BAIXA VERDE	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	72.93	27.07	836.0	0.0	NaN	NaN	NaN	NaN	4.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	607.0	0.0	606.0	1	229.0	229.0	418.0	NaN	NaN	229.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	RN	RN	NaN	229.0	NaN	0.000000	-45.215311	0.000000	4	8001	38585484.0	38585484.0	NaN	NaN	23412.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	0.0	0.0	0.0
5	634.266667	NaN	145.700000	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	ASSOCIACAO PRIVADA	ALTA	SERVICOS DE EDUCACAO	ACIMA DE 1 ANO	VERDE	2005-09-24	1016.48	10770780.0	30684070.0	False	True	False	False	True	False	False	False	False	True	SIM	False	False	False	False	True	True	NaN	NaN	11.0	15.0	144.0	5de08033561948a226f8ba8f8668a4ff4123be8ea7114d...	13.0	NaN	2.0	9.0	29.0	28.0	26.0	35.0	18.0	10.0	> 20	47.087671	634.266667	40.0	389.983333	389.983333	NaN	38.0	145.700000	36.0	10560780.0	25483750.0	15.0	309.0	397.633333	481.300000	4224312.0	10468051.0	5385390.0	15342035.0	10.0	159.0	99.530196	78.154236	4224312.0	5491605.5	20.433333	210000.0	5200320.0	5.0	9.0	20.433333	0.200000	4224312.0	515160.0	ENTIDADES SEM FINS LUCRATIVOS	EDUCACAO	LESTE POTIGUAR	NATAL	EDUCACAO	23.0	45.29	54.71	424.0	0.0	NaN	NaN	NaN	NaN	1.0	2.0	2.0	0.0	0.0	0.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	2.0	0.0	0.0	2.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	254.0	0.0	254.0	1	170.0	170.0	206.0	112.0	318.0	393.0	2.0	1.0	3.0	2.0	NaN	2.0	NaN	3.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	1.0	SERVIÇO	RN	RN	10770780.0	170.0	20.0	0.000000	-17.475728	0.000000	5	8272	42500700.0	93862150.0	4224312.0	10983211.0	141655.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2.0	4.0	1.0	1.0
6	NaN	NaN	NaN	NaN	DE R$ 100.000.000,01 A R$ 300.000.000,00	DE R$ 100.000.000,01 A R$ 300.000.000,00	BOA	ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU D...	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	VERDE	2003-02-06	1811.66	NaN	NaN	False	False	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	False	NaN	NaN	53.0	297.0	268.0	194e619cb6417f92f75653406cf04106debc5035f13a88...	216.0	NaN	5.0	15.0	43.0	42.0	29.0	51.0	78.0	139.0	15 a 20	15.734247	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	191.600000	467.233333	NaN	NaN	NaN	NaN	NaN	NaN	138.385891	126.687314	NaN	NaN	24.200000	NaN	NaN	NaN	NaN	24.200000	2.566667	NaN	NaN	ADMINISTRACAO PUBLICA	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	49.35	50.65	896.0	0.0	NaN	NaN	NaN	NaN	3.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	277.0	0.0	278.0	0	619.0	619.0	690.0	NaN	NaN	618.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	MA	MA	NaN	618.0	NaN	0.000000	-10.289855	0.000000	6	8626	195554740.0	195554740.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0
7	NaN	NaN	NaN	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	EMPRESARIO INDIVIDUAL	ALTA	SERVICOS DE ALOJAMENTO/ALIMENTACAO	ACIMA DE 1 ANO	VERDE	2003-03-15	857.89	NaN	NaN	False	False	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	True	NaN	NaN	18.0	143.0	7.0	cc734f72fdd8753ba2e7638f3d09e0597fd859735904da...	3.0	NaN	10.0	26.0	34.0	38.0	28.0	18.0	7.0	4.0	> 20	26.520548	NaN	63.0	NaN	NaN	NaN	63.0	NaN	63.0	NaN	NaN	NaN	NaN	274.300000	274.300000	NaN	NaN	NaN	NaN	NaN	NaN	44.566270	29.254984	NaN	NaN	2.433333	NaN	NaN	NaN	NaN	2.433333	-0.600000	NaN	NaN	OUTROS	ALIMENTACAO	CENTRO AMAZONENSE	MANAUS	ALOJAMENTO E ALIMENTACAO	23.0	22.62	77.38	428.0	10.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	260.0	2.0	260.0	1	168.0	160.0	186.0	NaN	NaN	168.0	NaN	NaN	1.0	NaN	NaN	1.0	NaN	1.0	0.0	NaN	NaN	NaN	NaN	NaN	1.0	NaN	NaN	SERVIÇO	AM	AM	NaN	168.0	NaN	5.000000	-9.677419	1.219512	7	8986	26994384.0	27924384.0	NaN	NaN	382387.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3.0	3.0	5.0	5.0
8	61.333333	NaN	17.933333	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS	ACIMA DE 1 ANO	VERDE	2010-05-20	NaN	19171824.0	19381824.0	False	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	True	2.0	NaN	17.0	98.0	64.0	7e46107cb32e64f7f90ec16372d29f205f0d9781140308...	6.0	5.0	10.0	36.0	40.0	43.0	19.0	11.0	7.0	4.0	5 a 10	8.446575	61.333333	41.0	32.544444	32.544444	NaN	40.0	17.933333	39.0	18751824.0	18961824.0	1.0	118.0	83.733333	83.733333	7500729.5	7500729.5	6390608.0	6460608.0	1.0	118.0	30.029853	18.908407	7500729.5	7500729.5	2.033333	210000.0	210000.0	1.0	118.0	2.033333	-0.600000	7500729.5	7500729.5	ENTIDADES EMPRESARIAIS	SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...	VALE DO ACRE	RIO BRANCO	ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS	23.0	28.18	71.82	452.0	58.0	NaN	NaN	NaN	NaN	6.0	3.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	0.0	0.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	270.0	49.0	270.0	0	182.0	179.0	131.0	118.0	118.0	181.0	1.0	1.0	2.0	5.0	NaN	2.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	1.0	SERVIÇO	AC	AC	19171824.0	181.0	3.0	1.675978	38.931298	27.605634	8	10968	35185428.0	35185428.0	7500729.5	7500729.5	559626.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11.0	11.0	1.0	1.0
9	116.133333	NaN	116.133333	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	SERVICOS ADMINISTRATIVOS	ACIMA DE 1 ANO	VERDE	2007-10-18	2346.09	23182200.0	23182200.0	False	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	True	NaN	NaN	15.0	117.0	16.0	2206453fbc92af65e47ce6ee2be27fa90ac427845ea0a5...	1.0	NaN	23.0	41.0	21.0	26.0	16.0	11.0	7.0	2.0	10 a 15	11.035616	116.133333	64.0	116.133333	116.133333	NaN	49.0	116.133333	34.0	23182200.0	23182200.0	NaN	161.0	113.533333	113.533333	9272880.0	9272880.0	23182200.0	23182200.0	NaN	161.0	40.449775	21.582770	9272880.0	9272880.0	2.933333	23182200.0	23182200.0	NaN	161.0	2.933333	-0.500000	9272880.0	9272880.0	ENTIDADES EMPRESARIAIS	SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGIST...	NaN	NaN	ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...	23.0	61.49	38.51	978.0	29.0	NaN	NaN	NaN	NaN	NaN	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	1.0	0.0	0.0	0.0	830.0	50.0	830.0	0	148.0	167.0	220.0	161.0	161.0	148.0	1.0	1.0	2.0	1.0	1.0	1.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	1.0	SERVIÇO	RO	RO	23182200.0	148.0	NaN	-11.377246	-32.727273	31.545741	9	12743	22357944.0	22357944.0	9272880.0	9272880.0	248083.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3.0	3.0	0.0	0.0

Last rows

	coligada_mais_antiga_ativa	coligada_mais_antiga_baixada	coligada_mais_nova_ativa	coligada_mais_nova_baixada	de_faixa_faturamento_estimado	de_faixa_faturamento_estimado_grupo	de_indicador_telefone	de_natureza_juridica	de_nivel_atividade	de_ramo	de_saude_rescencia	de_saude_tributaria	dt_situacao	empsetorcensitariofaixarendapopulacao	faturamento_est_coligados	faturamento_est_coligados_gp	fl_antt	fl_email	fl_epp	fl_ltda	fl_matriz	fl_me	fl_mei	fl_optante_simei	fl_optante_simples	fl_passivel_iss	fl_rm	fl_sa	fl_simples_irregular	fl_spa	fl_st_especial	fl_telefone	fl_veiculo	grau_instrucao_macro_analfabeto	grau_instrucao_macro_desconhecido	grau_instrucao_macro_escolaridade_fundamental	grau_instrucao_macro_escolaridade_media	grau_instrucao_macro_escolaridade_superior	id	idade_acima_de_58	idade_ate_18	idade_de_19_a_23	idade_de_24_a_28	idade_de_29_a_33	idade_de_34_a_38	idade_de_39_a_43	idade_de_44_a_48	idade_de_49_a_53	idade_de_54_a_58	idade_emp_cat	idade_empresa_anos	idade_maxima_coligadas	idade_maxima_socios	idade_media_coligadas	idade_media_coligadas_ativas	idade_media_coligadas_baixadas	idade_media_socios	idade_minima_coligadas	idade_minima_socios	max_faturamento_est_coligados	max_faturamento_est_coligados_gp	max_filiais_coligados	max_funcionarios_coligados_gp	max_meses_servicos	max_meses_servicos_all	max_vl_folha_coligados	max_vl_folha_coligados_gp	media_faturamento_est_coligados	media_faturamento_est_coligados_gp	media_filiais_coligados	media_funcionarios_coligados_gp	media_meses_servicos	media_meses_servicos_all	media_vl_folha_coligados	media_vl_folha_coligados_gp	meses_ultima_contratacaco	min_faturamento_est_coligados	min_faturamento_est_coligados_gp	min_filiais_coligados	min_funcionarios_coligados_gp	min_meses_servicos	min_meses_servicos_all	min_vl_folha_coligados	min_vl_folha_coligados_gp	natureza_juridica_macro	nm_divisao	nm_meso_regiao	nm_micro_regiao	nm_segmento	nu_meses_rescencia	percent_func_genero_fem	percent_func_genero_masc	qt_admitidos	qt_admitidos_12meses	qt_alteracao_socio_180d	qt_alteracao_socio_365d	qt_alteracao_socio_90d	qt_alteracao_socio_total	qt_art	qt_coligadas	qt_coligados	qt_coligados_agropecuaria	qt_coligados_atividade_alto	qt_coligados_atividade_baixo	qt_coligados_atividade_inativo	qt_coligados_atividade_medio	qt_coligados_atividade_mt_baixo	qt_coligados_ativo	qt_coligados_baixada	qt_coligados_ccivil	qt_coligados_centro	qt_coligados_comercio	qt_coligados_epp	qt_coligados_exterior	qt_coligados_inapta	qt_coligados_industria	qt_coligados_ltda	qt_coligados_matriz	qt_coligados_me	qt_coligados_mei	qt_coligados_nordeste	qt_coligados_norte	qt_coligados_nula	qt_coligados_sa	qt_coligados_serviço	qt_coligados_sudeste	qt_coligados_sul	qt_coligados_suspensa	qt_desligados	qt_desligados_12meses	qt_ex_funcionarios	qt_filiais	qt_funcionarios	qt_funcionarios_12meses	qt_funcionarios_24meses	qt_funcionarios_coligados	qt_funcionarios_coligados_gp	qt_funcionarios_grupo	qt_ramos_coligados	qt_regioes_coligados	qt_socios	qt_socios_coligados	qt_socios_feminino	qt_socios_masculino	qt_socios_pep	qt_socios_pf	qt_socios_pj	qt_socios_pj_ativos	qt_socios_pj_baixados	qt_socios_pj_inaptos	qt_socios_pj_nulos	qt_socios_pj_suspensos	qt_socios_st_regular	qt_socios_st_suspensa	qt_ufs_coligados	setor	sg_uf	sg_uf_matriz	sum_faturamento_estimado_coligadas	total	total_filiais_coligados	tx_crescimento_12meses	tx_crescimento_24meses	tx_rotatividade	Unnamed_0_x	Unnamed_0_y	vl_faturamento_estimado_aux	vl_faturamento_estimado_grupo_aux	vl_folha_coligados	vl_folha_coligados_gp	vl_frota	vl_idade_maxima_socios_pj	vl_idade_media_socios_pj	vl_idade_minima_socios_pj	vl_potenc_cons_oleo_gas	vl_total_tancagem	vl_total_tancagem_grupo	vl_total_veiculos_antt	vl_total_veiculos_antt_grupo	vl_total_veiculos_leves	vl_total_veiculos_leves_grupo	vl_total_veiculos_pesados	vl_total_veiculos_pesados_grupo
255	NaN	NaN	NaN	NaN	DE R$ 100.000.000,01 A R$ 300.000.000,00	DE R$ 100.000.000,01 A R$ 300.000.000,00	NaN	ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU D...	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	VERDE	2005-11-03	3419.68	NaN	NaN	False	True	False	False	True	False	False	False	False	True	SIM	False	False	False	False	True	True	NaN	NaN	63.0	271.0	229.0	1ec76d8ef1d7c6bb73ef86a43d713725b1b610240bdf4a...	210.0	1.0	8.0	11.0	40.0	28.0	30.0	48.0	71.0	116.0	15 a 20	19.843836	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	490.433333	490.433333	NaN	NaN	NaN	NaN	NaN	NaN	180.181442	97.031514	NaN	NaN	3.466667	NaN	NaN	NaN	NaN	3.466667	1.800000	NaN	NaN	ADMINISTRACAO PUBLICA	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	22.0	55.42	44.58	1484.0	6.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	920.0	8.0	920.0	0	564.0	566.0	615.0	NaN	NaN	563.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	MA	MA	NaN	563.0	NaN	-0.353357	-8.292683	1.415929	255	452076	169642190.0	169642190.0	NaN	NaN	10151299.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	101.0	101.0	0.0	0.0
256	516.933333	NaN	39.733333	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	SERVICOS DE SAUDE	ACIMA DE 1 ANO	VERDE	2005-11-03	2348.34	3.915216e+06	3.915216e+06	False	True	False	False	True	False	False	False	False	True	SIM	False	False	False	False	True	True	NaN	NaN	12.0	91.0	42.0	a3d4217a7c01f6cabd26d86cb283923c682a18d516f015...	NaN	NaN	13.0	23.0	32.0	33.0	18.0	16.0	6.0	4.0	15 a 20	19.761644	516.933333	44.0	203.111111	203.111111	NaN	41.5	39.733333	39.0	2.843683e+06	2.843683e+06	NaN	13.0	121.600000	121.600000	947894.4	947894.4	1.305072e+06	1.305072e+06	NaN	7.000000	52.999543	40.757037	4.533408e+05	4.533408e+05	3.933333	329702.4	329702.4	NaN	4.0	3.933333	0.466667	164851.2	164851.2	ENTIDADES EMPRESARIAIS	ATIVIDADES DE ATENCAO A SAUDE HUMANA	CENTRO NORTE PIAUIENSE	TERESINA	SAUDE HUMANA E SERVICOS SOCIAIS	23.0	69.66	30.34	270.0	14.0	NaN	NaN	NaN	NaN	NaN	3.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	0.0	3.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	124.0	9.0	124.0	3	146.0	141.0	166.0	21.0	21.0	145.0	3.0	1.0	2.0	4.0	1.0	1.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	1.0	SERVIÇO	PI	PI	3.915216e+06	145.0	NaN	3.546099	-12.048193	6.271777	256	452130	24727680.0	28697680.0	1.360022e+06	1.360022e+06	182413.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4.0	4.0	2.0	2.0
257	25.566667	NaN	25.566667	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITAD...	ALTA	SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS	ACIMA DE 1 ANO	VERDE	2005-10-14	3021.53	2.100000e+05	2.100000e+05	False	False	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	True	1.0	NaN	73.0	122.0	5.0	feb9c97a3f694c22a919d9544c433da92d34d5717b43d5...	2.0	NaN	19.0	28.0	46.0	35.0	27.0	19.0	16.0	9.0	15 a 20	16.769863	25.566667	NaN	25.566667	25.566667	NaN	NaN	25.566667	NaN	2.100000e+05	2.100000e+05	NaN	NaN	92.233333	92.233333	NaN	NaN	2.100000e+05	2.100000e+05	NaN	NaN	18.929612	8.896976	NaN	NaN	3.700000	210000.0	210000.0	NaN	NaN	3.700000	-0.533333	NaN	NaN	OUTROS	SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS	23.0	4.98	95.02	983.0	230.0	NaN	NaN	NaN	NaN	5.0	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	1.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	777.0	186.0	774.0	0	206.0	152.0	119.0	NaN	NaN	201.0	1.0	1.0	1.0	1.0	NaN	NaN	NaN	1.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	SERVIÇO	MA	MA	2.100000e+05	201.0	NaN	35.526316	73.109244	101.086957	257	452676	31321728.0	31321728.0	NaN	NaN	85833.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4.0	4.0	0.0	0.0
258	NaN	NaN	NaN	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL	MEDIA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	AZUL	2000-12-27	1359.01	NaN	NaN	False	False	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	False	NaN	NaN	18.0	305.0	55.0	efd51c8f53a5931f1778398c485a861169c99a40072d8f...	206.0	NaN	2.0	2.0	10.0	13.0	11.0	9.0	51.0	74.0	15 a 20	17.846575	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	607.633333	607.633333	NaN	NaN	NaN	NaN	NaN	NaN	353.954938	281.495431	NaN	NaN	37.266667	NaN	NaN	NaN	NaN	37.266667	-0.266667	NaN	NaN	ADMINISTRACAO PUBLICA	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	CENTRO NORTE PIAUIENSE	TERESINA	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	14.02	85.98	572.0	0.0	NaN	NaN	NaN	NaN	6.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	194.0	0.0	194.0	0	378.0	378.0	379.0	NaN	NaN	378.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	PI	PI	NaN	378.0	NaN	0.000000	-0.263852	0.000000	258	453793	59810076.0	59810076.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0
259	NaN	NaN	NaN	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	NaN	MUNICIPIO	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	AZUL	2005-04-02	372.23	NaN	NaN	False	False	False	False	True	False	False	False	False	True	NAO	False	False	False	False	False	True	NaN	NaN	15.0	305.0	33.0	120ecac76e64ace3880969e7a6c7a20ff116b94a411fd0...	23.0	NaN	2.0	5.0	35.0	44.0	92.0	60.0	61.0	31.0	> 20	43.539726	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	501.066667	5014.966667	NaN	NaN	NaN	NaN	NaN	NaN	181.592823	92.680587	NaN	NaN	2.500000	NaN	NaN	NaN	NaN	2.500000	-5.100000	NaN	NaN	OUTROS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	LESTE POTIGUAR	LITORAL NORDESTE	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	52.12	47.88	977.0	9.0	NaN	NaN	NaN	NaN	18.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	624.0	0.0	624.0	1	353.0	344.0	564.0	NaN	NaN	353.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	RN	RN	NaN	353.0	NaN	2.616279	-37.411348	0.000000	259	454341	63313164.0	63313164.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	0.0	1.0	1.0
260	206.900000	NaN	27.166667	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	COOPERATIVA	ALTA	SERVICOS FINANCEIROS	ACIMA DE 1 ANO	VERDE	2005-11-03	1365.70	1.462024e+07	1.779363e+07	False	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	False	NaN	NaN	NaN	16.0	72.0	b6966d868fb7976f993aca02fb667c9ae8f5ebf4d2e033...	5.0	2.0	6.0	24.0	18.0	21.0	2.0	6.0	2.0	2.0	15 a 20	18.980822	206.900000	52.0	126.222222	126.222222	NaN	52.0	27.166667	52.0	1.045775e+07	1.045775e+07	3.0	57.0	176.300000	218.200000	4183099.2	4183099.2	4.873414e+06	5.931209e+06	3.0	42.333333	51.353933	43.703509	2.088115e+06	2.617013e+06	2.266667	700617.6	3461875.2	3.0	26.0	2.266667	-0.300000	350308.8	1730937.6	ENTIDADES EMPRESARIAIS	ATIVIDADES DE SERVICOS FINANCEIROS	NaN	NaN	ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS R...	23.0	55.68	44.32	152.0	12.0	NaN	NaN	NaN	NaN	NaN	3.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	0.0	0.0	1.0	0.0	0.0	3.0	2.0	0.0	0.0	63.0	9.0	63.0	0	89.0	86.0	73.0	106.0	127.0	88.0	3.0	2.0	2.0	3.0	NaN	1.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	1.0	NaN	2.0	SERVIÇO	RO	RO	1.462024e+07	88.0	3.0	3.488372	21.917808	10.285714	260	454844	23903424.0	23903424.0	6.264346e+06	7.851038e+06	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0
261	158.600000	NaN	20.600000	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	SERVICOS DE SAUDE	ACIMA DE 1 ANO	VERDE	2002-11-16	2484.07	4.200000e+05	4.200000e+05	False	False	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	True	1.0	NaN	4.0	119.0	73.0	4a87a82771996c18afc68a17d139bd318d08fa3e5dcf9f...	NaN	6.0	20.0	46.0	44.0	34.0	23.0	12.0	8.0	4.0	> 20	22.493151	158.600000	51.0	89.600000	89.600000	NaN	36.0	20.600000	27.0	2.100000e+05	2.100000e+05	NaN	NaN	271.800000	271.800000	NaN	NaN	2.100000e+05	2.100000e+05	NaN	NaN	63.100493	49.762882	NaN	NaN	2.533333	210000.0	210000.0	NaN	NaN	2.533333	0.600000	NaN	NaN	ENTIDADES EMPRESARIAIS	ATIVIDADES DE ATENCAO A SAUDE HUMANA	CENTRO NORTE PIAUIENSE	TERESINA	SAUDE HUMANA E SERVICOS SOCIAIS	25.0	68.02	31.98	414.0	27.0	NaN	NaN	NaN	NaN	4.0	2.0	2.0	0.0	0.0	0.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	2.0	0.0	0.0	2.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	211.0	30.0	210.0	3	203.0	206.0	243.0	NaN	NaN	224.0	2.0	1.0	4.0	5.0	1.0	2.0	NaN	4.0	0.0	NaN	NaN	NaN	NaN	NaN	3.0	NaN	1.0	SERVIÇO	PI	PI	4.200000e+05	197.0	NaN	-1.456311	-16.460905	14.669927	261	457457	30136860.0	33145394.0	NaN	NaN	447145.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7.0	7.0	0.0	0.0
262	56.200000	NaN	56.200000	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS	ACIMA DE 1 ANO	VERDE	2006-02-01	NaN	9.300000e+05	9.300000e+05	False	True	False	False	True	False	False	False	False	True	SIM	False	False	False	False	True	False	NaN	NaN	150.0	127.0	2.0	f3b468c4066fac0d2de28bdafa87ec8b9d103a085cf7de...	34.0	NaN	6.0	21.0	26.0	45.0	41.0	43.0	44.0	19.0	10 a 15	12.745205	56.200000	49.0	56.200000	56.200000	NaN	41.0	56.200000	33.0	9.300000e+05	9.300000e+05	NaN	NaN	5099.066667	5099.066667	NaN	NaN	9.300000e+05	9.300000e+05	NaN	NaN	173.809677	61.097177	NaN	NaN	20.733333	930000.0	930000.0	NaN	NaN	24.700000	-0.566667	NaN	NaN	ENTIDADES EMPRESARIAIS	SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...	CENTRO AMAZONENSE	MANAUS	ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS	23.0	63.44	36.56	981.0	0.0	NaN	NaN	NaN	NaN	NaN	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	1.0	0.0	0.0	0.0	702.0	8.0	702.0	0	279.0	287.0	296.0	NaN	NaN	279.0	1.0	1.0	2.0	1.0	NaN	2.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	1.0	SERVIÇO	AM	AM	9.300000e+05	279.0	NaN	-2.787456	-5.743243	2.826855	262	457917	40955220.0	40955220.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0
263	321.633333	NaN	10.366667	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	COOPERATIVA	ALTA	SEGUROS, PLANOS DE PREVIDENCIA E PLANOS DE SAUDE	ACIMA DE 1 ANO	AZUL	2003-11-08	2281.44	2.275368e+07	2.720860e+07	False	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	True	NaN	NaN	6.0	45.0	69.0	98448fefe3e358578fa643b63fcdcf4a3f2dcb496863f8...	3.0	7.0	9.0	22.0	22.0	21.0	12.0	12.0	6.0	6.0	> 20	26.402740	321.633333	70.0	166.300000	166.300000	NaN	59.5	10.366667	45.0	2.107004e+07	2.552496e+07	4.0	72.0	286.333333	286.333333	8428018.0	10550477.0	3.792280e+06	4.534767e+06	3.5	36.500000	67.994215	55.208629	4.244919e+06	5.306148e+06	2.933333	123638.4	123638.4	3.0	1.0	2.933333	0.333333	61819.2	61819.2	ENTIDADES EMPRESARIAIS	SEGUROS RESSEGUROS PREVIDENCIA COMPLEMENTAR E ...	VALE DO ACRE	RIO BRANCO	ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS R...	23.0	70.83	29.17	282.0	18.0	NaN	NaN	NaN	NaN	1.0	6.0	6.0	0.0	0.0	0.0	0.0	0.0	0.0	6.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	1.0	6.0	0.0	0.0	0.0	5.0	0.0	0.0	5.0	1.0	0.0	0.0	161.0	11.0	160.0	5	121.0	114.0	109.0	59.0	73.0	319.0	4.0	2.0	4.0	6.0	1.0	3.0	NaN	4.0	0.0	NaN	NaN	NaN	NaN	NaN	4.0	NaN	3.0	SERVIÇO	AC	AC	2.275368e+07	120.0	7.0	6.140351	11.009174	9.361702	263	459287	30033828.0	61489496.0	8.489837e+06	1.061230e+07	156585.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2.0	2.0	1.0	1.0
264	596.233333	NaN	16.700000	NaN	DE R$ 300.000.000,01 A R$ 500.000.000,00	DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	BOA	SOCIEDADE ANONIMA FECHADA	ALTA	INDUSTRIA DIGITAL	ACIMA DE 1 ANO	VERDE	2008-01-14	5985.49	5.223031e+09	5.451955e+09	False	True	False	False	True	False	False	False	False	True	SIM	True	False	False	False	True	False	NaN	NaN	140.0	2447.0	563.0	251f454db948590c50df496ea83f76e2227e24a32c2814...	5.0	7.0	643.0	949.0	749.0	444.0	200.0	95.0	41.0	17.0	10 a 15	10.794521	596.233333	72.0	106.631111	106.631111	NaN	52.5	16.700000	35.0	5.150974e+09	5.372531e+09	275.0	1716.0	30.333333	146.600000	171568880.0	241816100.0	3.482021e+08	3.634637e+08	24.0	361.600000	23.341541	18.284345	3.669588e+07	5.131406e+07	3.433333	210000.0	210000.0	1.0	10.0	3.433333	-0.466667	288489.6	288489.6	ENTIDADES EMPRESARIAIS	ATIVIDADES DE PRESTACAO DE SERVICOS DE INFORMACAO	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	INFORMACAO E COMUNICACAO	23.0	33.56	66.44	5340.0	465.0	NaN	NaN	NaN	NaN	NaN	15.0	15.0	1.0	0.0	0.0	0.0	0.0	0.0	15.0	0.0	0.0	8.0	1.0	0.0	0.0	0.0	10.0	0.0	15.0	0.0	0.0	4.0	1.0	0.0	10.0	3.0	2.0	0.0	0.0	2168.0	394.0	2162.0	6	3172.0	3186.0	3460.0	1229.0	1808.0	3787.0	7.0	4.0	5.0	28.0	NaN	4.0	NaN	5.0	0.0	NaN	NaN	NaN	NaN	NaN	4.0	NaN	5.0	SERVIÇO	MA	MA	5.223031e+09	3150.0	288.0	-0.439422	-8.323699	12.561773	264	460027	459934850.0	560530400.0	1.834794e+08	2.565703e+08	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows